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