Operation Details
Description: Counts service plans that the goal is associated with.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :recordCount 
FROM
  ServicePlanGoalLink,
  ServicePlan 
WHERE ServicePlanGoalLink.goalID = :goalID 
  AND ServicePlanGoalLink.servicePlanID = ServicePlan.servicePlanID 
  AND ServicePlan.recordStatus = :recordStatus