| Operation Details |  |
| Description: | Counts service plans that the plan template is associated with. |
| Sterotype: | ns |
| SQL | |
SELECT COUNT(*) INTO :count FROM PlanTemplateServicePlanLink, ServicePlan WHERE PlanTemplateServicePlanLink.planTemplateID = :planTemplateID AND PlanTemplateServicePlanLink.servicePlanID = ServicePlan.servicePlanID AND ServicePlan.recordStatus = :recordStatus |