Operation Details
Description: Returns the max and min actual and expected dates for all planned group (who have no parent group) that belong to this goal.
Sterotype: ns
SQL 
SELECT
  MIN(PlannedGroup.actualStartDate),
  MAX(PlannedGroup.actualEndDate),
  MIN(PlannedGroup.expectedStartDate),
  MAX(PlannedGroup.expectedEndDate)
INTO
  :actualStartDate,
  :actualEndDate,
  :expectedStartDate,
  :expectedEndDate 
FROM
  PlannedGroup 
WHERE PlannedGroup.plannedGoalID = :plannedGoalID 
  AND PlannedGroup.parentGroupID IS NULL