Operation Details
Description: Lists all sub goals that are not associated with goal specified, having a specific record status.
Sterotype: nsmulti
SQL 
SELECT
  subGoalID,
  name,
  dateCreated
INTO
  :subGoalID,
  :name,
  :dateCreated 
FROM
  SubGoal 
WHERE recordStatus = :subGoalRecordStatus 
  AND subGoalID NOT IN 
  ( 
  SELECT
    subGoalID 
  FROM
    GoalSubGoalLink 
  WHERE goalID = :goalID 
  )