Operation Details
Description: Lists all sub goals of the particular type assigned to a goal.
Sterotype: nsmulti
SQL 
SELECT
  SubGoal.name,
  SubGoal.description,
  SubGoal.subGoalID
INTO
  :name,
  :description,
  :subGoalID 
FROM
  GoalSubGoalLink,
  SubGoal 
WHERE GoalSubGoalLink.goalID = :goalID 
  AND SubGoal.subGoalID = GoalSubGoalLink.subGoalID 
  AND SubGoal.typeCode = :typeCode