Operation Details
Description: Returns the max and min actual and expected dates of all the subgoals(that do not have a parent group id set) belonging to this goal.
Sterotype: ns
SQL 
SELECT
  MIN(PlannedSubGoal.actualStartDate),
  MAX(PlannedSubGoal.actualEndDate),
  MIN(PlannedSubGoal.expectedStartDate),
  MAX(PlannedSubGoal.expectedEndDate)
INTO
  :actualStartDate,
  :actualEndDate,
  :expectedStartDate,
  :expectedEndDate 
FROM
  PlannedSubGoal 
WHERE PlannedSubGoal.plannedGoalID = :plannedGoalID 
  AND PlannedSubGoal.plannedGroupID IS NULL