Operation Details
Description: Reads a list of all sub goal details for a specific Planned Group.
Sterotype: nsmulti
SQL 
SELECT
  PlannedSubGoal.plannedSubGoalID,
  SubGoal.name,
  SubGoal.typeCode,
  PlannedSubGoal.expectedStartDate,
  PlannedSubGoal.expectedEndDate,
  PlannedSubGoal.actualStartDate,
  PlannedSubGoal.actualEndDate
INTO
  :plannedSubGoalID,
  :name,
  :typeCode,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  PlannedSubGoal,
  SubGoal 
WHERE PlannedSubGoal.plannedGroupID = :plannedGroupID 
  AND PlannedSubGoal.sensitivityCode <= :sensitivityCode 
  AND SubGoal.subGoalID = PlannedSubGoal.subGoalID