Operation Details
Description: Reads details about all baseline sub goals for a baseline.
Sterotype: nsmulti
SQL
SELECT
  BaselineSubGoal.baselineSubGoalID,
  PlannedSubGoal.plannedSubGoalID,
  SubGoal.name,
  SubGoal.typeCode,
  PlannedSubGoal.expectedStartDate,
  PlannedSubGoal.expectedEndDate
INTO
  :baselineSubGoalID,
  :plannedSubGoalID,
  :name,
  :typeCode,
  :expectedStartDate,
  :expectedEndDate 
FROM
  BaselineSubGoal,
  PlannedSubGoal,
  SubGoal 
WHERE BaselineSubGoal.baseLineID = :baseLineID 
  AND BaselineSubGoal.sensitivityCode <= :sensitivityCode 
  AND PlannedSubGoal.plannedSubGoalID = BaselineSubGoal.plannedSubGoalID 
  AND SubGoal.subGoalID = PlannedSubGoal.subGoalID