Operation Details
Description: Lists all sub goals associated with the selected goal of the service plan template.
Sterotype: nsmulti
SQL 
SELECT
  SubGoal.subGoalID,
  SubGoal.name
INTO
  :subGoalID,
  :name 
FROM
  SubGoal,
  GoalSubGoalLink,
  PlanTemplate 
WHERE PlanTemplate.planTemplateID = :planTemplateID 
  AND PlanTemplate.goalID = GoalSubGoalLink.goalID 
  AND GoalSubGoalLink.subGoalID = SubGoal.subGoalID 
  AND SubGoal.recordStatus = :recordStatus