Operation Details
Description: Reads the min and max dates for all subgoal for who have a specific plan group set as their parent group id.
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.plannedGroupID = :plannedGroupID