Operation Details
Description: Counts all planed planItems for a service plan delivery.
Sterotype: ns
SQL
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  PlannedGoal,
  PlannedSubGoal,
  PlannedItem 
WHERE PlannedGoal.caseID = :caseID 
  AND PlannedSubGoal.plannedGoalID = PlannedGoal.plannedGoalID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID