Operation Details
Description: Reads goal name and goal id for the service plan delivery.
Sterotype: ns
SQL
SELECT
  Goal.name,
  Goal.goalID
INTO
  :name,
  :goalID 
FROM
  PlannedGoal,
  Goal 
WHERE PlannedGoal.caseID = :caseID 
  AND Goal.goalID = PlannedGoal.goalID