Operation Details
Description: Reads the goal details for the tracking gantt.
Sterotype: ns
SQL 
SELECT
  PlannedGoal.plannedGoalID,
  PlannedGoal.caseID,
  Goal.name,
  PlannedGoal.expectedStartDate,
  PlannedGoal.expectedEndDate,
  PlannedGoal.actualStartDate,
  PlannedGoal.actualEndDate
INTO
  :plannedGoalID,
  :caseID,
  :goalName,
  :expectedStartDate,
  :expectedEndDate,
  :actualStartDate,
  :actualEndDate 
FROM
  PlannedGoal,
  Goal 
WHERE PlannedGoal.caseID = :caseID 
  AND Goal.goalID = PlannedGoal.goalID