Operation Details
Description: @Deprecated since curam 6.0 replaced by {@link ServicePlan#searchUnassociatedPlanTemplatesByStatus} as part of localizing Plan Template name. See release note: CR00227878 Gets a list of templates that are not associated with the service plan referenced by the key.
Sterotype: nsmulti
SQL 
SELECT
  planTemplateID,
  name,
  dateCreated
INTO
  :planTemplateID,
  :planTemplateName,
  :dateCreated 
FROM
  PlanTemplate 
WHERE recordStatus = :recordStatus 
  AND planTemplateID NOT IN 
  ( 
  SELECT
    planTemplateID 
  FROM
    PlanTemplateServicePlanLink 
  WHERE servicePlanID = :servicePlanID 
  )