Operation Details
Description: Method to search parent plan groups for a service plan template.
Sterotype: nsmulti
SQL 
SELECT
  PlanTemplatePlanGroup.planTemplatePlanGroupID,
  PlanTemplatePlanGroup.name,
  PlanTemplatePlanGroup.nameTextID
INTO
  :planTemplatePlanGroupID,
  :planTemplatePlanGroupName,
  :planGroupNameTextID
FROM
  PlanTemplatePlanGroup 
WHERE PlanTemplatePlanGroup.planTemplateID = :planTemplateID 
  AND PlanTemplatePlanGroup.parentGroupID is NULL
ORDER BY PlanTemplatePlanGroup.LastWritten