SELECT
  goodCauseID,
  goodCauseReference,
  description,
  name,
  dateCreated,
  recordStatus,
  versionNo
INTO
  :goodCauseID,
  :goodCauseReference,
  :description,
  :name,
  :dateCreated,
  :recordStatus,
  :versionNo 
FROM
  GoodCause 
WHERE recordStatus = :goodCauseStatus 
  AND goodCauseID NOT IN 
  ( 
  SELECT
    goodCauseID 
  FROM
    GoodCauseLink 
  WHERE relatedID = :relatedID 
  )