Operation Details
Description: Reads the status of the plan template that this plan group is assigned to.
Sterotype: ns
SQL 
SELECT
  PlanTemplate.recordStatus
INTO
  :recordStatus 
FROM
  PlanTemplate,
  PlanTemplatePlanGroup 
WHERE PlanTemplatePlanGroup.planTemplatePlanGroupID = :planTemplatePlanGroupID 
  AND PlanTemplatePlanGroup.planTemplateID = PlanTemplate.planTemplateID