Database SQL Operation: PlanTemplatePlanGroup.searchParentPlanGroupsForTemplate
Description: | @deprecated Since Curam 6.0, replaced with {@link PlanTemplatePlanGroup#searchParentPlanGroupNamesForTemplate()} as part of implementing localization of plan template plan group name. See release note: CR00235328.
Method to search parent plan groups for a service plan template. |
Sterotype: | nsmulti |
SELECT
PlanTemplatePlanGroup.planTemplatePlanGroupID,
PlanTemplatePlanGroup.name
INTO
:planTemplatePlanGroupID,
:planTemplatePlanGroupName
FROM
PlanTemplatePlanGroup
WHERE PlanTemplatePlanGroup.planTemplateID = :planTemplateID
AND PlanTemplatePlanGroup.parentGroupID is NULL
ORDER BY PlanTemplatePlanGroup.LastWritten
|