Operation Details
Description: Counts active service plans with the same type.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :servicePlanTypeCount 
FROM
  ServicePlan 
WHERE servicePlanType = :servicePlanType 
  AND recordStatus <> :recordStatus