Operation Details
Description: Reads planned group details for comparison when planned group is not associated with another group.
Sterotype: nsmulti
SQL 
SELECT
  PlannedGroup.plannedGroupID,
  PlannedGroup.parentGroupID,
  PlannedGroup.name,
  PlannedGroup.expectedStartDate,
  PlannedGroup.expectedEndDate,
  PlannedGroup.actualStartDate,
  PlannedGroup.actualEndDate
INTO
  :plannedGroupID,
  :parentGroupID,
  :plannedGroupName,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  PlannedGoal,
  PlannedGroup 
WHERE PlannedGoal.caseID = :caseID 
  AND PlannedGroup.plannedGoalID = PlannedGoal.plannedGoalID 
  AND PlannedGroup.parentGroupID IS NULL