Operation Details
Description: Returns the caseID of a service plan.
Sterotype: ns
SQL 
SELECT
  PlannedGoal.caseID
INTO
  :caseID 
FROM
  PlannedItem,
  PlannedSubGoal,
  PlannedGoal 
WHERE PlannedItem.plannedItemID = :plannedItemID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  AND PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID