SELECT
  PT.planTemplateID,
  PT.name,
  PT.nameTextID 
INTO
  :planTemplateID,
  :name,
  :nameTextID
FROM
  PlanTemplateServicePlanLink,
  PlanTemplate PT
WHERE PlanTemplateServicePlanLink.servicePlanID = :servicePlanID 
  AND PT.planTemplateID = PlanTemplateServicePlanLink.planTemplateID