Operation Details
Description: Reads plannedItemID for all planItems of the specific type on a service plan delivery.
Sterotype: nsmulti
SQL 
SELECT
  PlannedItem.plannedItemID
INTO
  :plannedItemID 
FROM
  PlannedGoal,
  PlannedSubGoal,
  PlannedItem 
WHERE PlannedGoal.caseID = :caseID 
  AND PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID 
  AND PlannedItem.status = :status