| Operation Details |  |
| Description: | Returns all subgoals for a given type |
| Sterotype: | nsmulti |
| SQL | |
SELECT SubGoal.name, SubGoal.description, SubGoal.subGoalID INTO :name, :description, :subGoalID FROM SubGoal WHERE SubGoal.typeCode = :typeCode AND SubGoal.recordStatus = :recordStatus |