Operation Details
Description: Reads goal name, goal ID, expectedStartDate and expectedEndDate for a baseline.
Sterotype: ns
SQL
SELECT
  Goal.name,
  Goal.goalID,
  PlannedGoal.plannedGoalID,
  Baseline.expectedStartDate,
  Baseline.expectedEndDate,
  Baseline.actualStartDate,
  Baseline.actualEndDate
INTO
  :name,
  :goalID,
  :plannedGoalID,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  Baseline,
  PlannedGoal,
  Goal 
WHERE Baseline.baseLineID = :baseLineID 
  AND PlannedGoal.plannedGoalID = Baseline.plannedGoalID 
  AND Goal.goalID = PlannedGoal.goalID