Operation Details
Description: Lists all goals not associated with the service plan referenced by key and having the specified status.
Sterotype: nsmulti
SQL 
SELECT
  goalID,
  name,
  dateCreated
INTO
  :goalID,
  :goalName,
  :dateCreated 
FROM
  Goal 
WHERE recordStatus = :recordStatus 
  AND goalID NOT IN 
  ( 
  SELECT
    goalID 
  FROM
    ServicePlanGoalLink 
  WHERE servicePlanID = :servicePlanID 
  )