SELECT
  outcomeID,
  name,
  dateCreated
INTO
  :outcomeID,
  :name,
  :dateCreated 
FROM
  Outcome 
WHERE recordStatus = :outcomeRecordStatus 
  AND outcomeID NOT IN 
  ( 
  SELECT
    outcomeID 
  FROM
    PlanItemOutcomeLink 
  WHERE planItemID = :planItemID 
  )