Operation Details
Description: Reads goalName, goalID, expectedStartDate and expectedEndDate for a planned goal.
Sterotype: ns
SQL 
SELECT
  Goal.name,
  Goal.goalID,
  PlannedGoal.expectedStartDate,
  PlannedGoal.expectedEndDate,
  PlannedGoal.actualStartDate,
  PlannedGoal.actualEndDate
INTO
  :name,
  :goalID,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  PlannedGoal,
  Goal 
WHERE PlannedGoal.caseID = :caseID 
  AND Goal.goalID = PlannedGoal.goalID