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