Operation Details
Description: Reads all the parent plan groups for a specified template.
Sterotype: nsmulti
SQL 
SELECT
  PlanTemplatePlanGroup.planTemplatePlanGroupID,
  PlanTemplatePlanGroup.name,
  PlanTemplatePlanGroup.comments
INTO
  :planTemplatePlanGroupID,
  :name,
  :comments 
FROM
  PlanTemplatePlanGroup 
WHERE PlanTemplatePlanGroup.planTemplateID = :planTemplateID 
  AND PlanTemplatePlanGroup.parentGroupID is NULL 
ORDER BY 
  lastWritten