| Operation Details |  |
| Description: | Counts sub goals that the plan item is associated with. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numPlanItems FROM SubGoalPlanItemLink, SubGoal WHERE SubGoalPlanItemLink.planItemID = :planItemID AND SubGoalPlanItemLink.subGoalID = SubGoal.subGoalID AND SubGoal.recordStatus = :recordStatus |