Operation Details
Description: Returns a list of Planned Groups for a specific Parent group for the tracking gantt.
Sterotype: nsmulti
SQL 
SELECT
  PlannedGroup.plannedGroupID,
  PlannedGroup.name,
  PlannedGroup.expectedStartDate,
  PlannedGroup.expectedEndDate,
  PlannedGroup.actualStartDate,
  PlannedGroup.actualEndDate,
  PlannedGoal.caseID
INTO
  :plannedGroupID,
  :name,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate,
  :caseID 
FROM
  PlannedGroup,
  PlannedGoal 
WHERE PlannedGroup.parentGroupID = :plannedGroupID 
  AND PlannedGoal.plannedGoalID = PlannedGroup.plannedGoalID