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 |