Database SQL Operation: ServicePlan.searchTemplates
| Description: | @Deprecated since curam 6.0 replaced by {@link ServicePlan#searchPlanTemplates}
as part of localizing Plan Template name. See release note: CR00227878
Gets a list of the plan templates that are associated with the service referenced by the provided key.
</p> |
| Sterotype: | nsmulti |
SELECT
planTemplateID,
name,
dateCreated
INTO
:planTemplateID,
:planTemplateName,
:dateCreated
FROM
PlanTemplate
WHERE planTemplateID IN
(
SELECT
planTemplateID
FROM
PlanTemplateServicePlanLink
WHERE servicePlanID = :servicePlanID
)
|
