| Operation Details |  |
| Description: | Count goals that the sub goal is associated with. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :numSubGoals FROM GoalSubGoalLink, Goal WHERE GoalSubGoalLink.subGoalID = :subGoalID AND GoalSubGoalLink.goalID = Goal.goalID AND Goal.recordStatus = :recordStatus |