Operation Details
Description: Counts all planned items on planned groups based on planned goal.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  PlannedGroup,
  PlannedSubGoal,
  PlannedItem 
WHERE PlannedGroup.plannedGoalID = :plannedGoalID 
  AND PlannedSubGoal.plannedGroupID = PlannedGroup.plannedGroupID 
  AND PlannedItem.plannedSubGoalID = PlannedSubGoal.plannedSubGoalID