Operation Details
Description: Returns list of planTemplateIDs and planTemplateNames for all plan templates assigned to a service plan.
Sterotype: nsmulti
SQL 
SELECT
  PlanTemplate.planTemplateID,
  PlanTemplate.name
INTO
  :planTemplateID,
  :name 
FROM
  PlanTemplateServicePlanLink,
  PlanTemplate 
WHERE PlanTemplateServicePlanLink.servicePlanID = :servicePlanID 
  AND PlanTemplate.planTemplateID = PlanTemplateServicePlanLink.planTemplateID