Operation Details
Description: Reads the status of the plan template this approval criteria is been assigned to.
Sterotype: ns
SQL 
SELECT
  PlanTemplate.recordStatus
INTO
  :recordStatus 
FROM
  PlanTemplate,
  PlanTemplateSubGoal,
  PlanTemplatePlanItem,
  PlanTemplatePlanItemApprCrit 
WHERE PlanTemplatePlanItemApprCrit .planTemplatePlanItemApprCritID = :planTemplatePlanItemApprCritID 
  AND PlanTemplatePlanItemApprCrit.planTemplatePlanItemID = PlanTemplatePlanItem.planTemplatePlanItemID 
  AND PlanTemplateSubGoal.planTemplateSubGoalID = PlanTemplatePlanItem.planTemplateSubGoalID 
  AND PlanTemplateSubGoal.planTemplateID = PlanTemplate.planTemplateID