SELECT
  goodCauseID,
  name,
  dateCreated
INTO
  :goodCauseID,
  :name,
  :dateCreated 
FROM
  GoodCause 
WHERE recordStatus = :goodCauseRecordStatus 
  AND goodCauseID NOT IN 
  ( 
  SELECT
    goodCauseID 
  FROM
    PlanItemGoodCauseLink 
  WHERE planItemID = :planItemID 
  )