Operation Details
Description: Reads plannedGoalID, name and service plan status.
Sterotype: ns
SQL 
SELECT
  PlannedGoal.caseID,
  PlannedGoal.plannedGoalID,
  Goal.name,
  CaseHeader.statusCode
INTO
  :caseID,
  :plannedGoalID,
  :goalName,
  :plannedGoalStatus 
FROM
  PlannedGoal,
  Goal,
  CaseHeader 
WHERE 
  (
    PlannedGoal.caseID = :caseID 
  ) 
  AND 
  (
    CaseHeader.caseID = PlannedGoal.caseID 
  ) 
  AND 
  (
    PlannedGoal.goalID = Goal.goalID 
  )