Operation Details
Description: Reads service plan ID of the service plan delivery.
Sterotype: ns
SQL 
SELECT
  ServicePlanDelivery.servicePlanID
INTO
  :servicePlanID 
FROM
  PlannedItem,
  PlannedSubGoal,
  PlannedGoal,
  ServicePlanDelivery 
WHERE PlannedItem.plannedItemID = :plannedItemID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  AND PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  AND ServicePlanDelivery.caseID = PlannedGoal.caseID