SELECT
  planTemplateID,
  name,
 nameTextID,
  dateCreated
INTO
  :planTemplateID,
  :planTemplateName,
  :nameTextID,
  :dateCreated 
FROM
  PlanTemplate PT
WHERE planTemplateID IN 
  ( 
  SELECT
    planTemplateID 
  FROM
    PlanTemplateServicePlanLink 
  WHERE servicePlanID = :servicePlanID 
  )