SELECT
  outcomeID,
  outcomeName,
  type,
  startDate,
  endDate,
  comments,
  createdBy,
  dateCreated,
  versionNo,
  recordStatus
INTO
  :outcomeID,
  :outcomeName,
  :type,
  :startDate,
  :endDate,
  :comments,
  :createdBy,
  :dateCreated,
  :versionNo,
  :recordStatus 
FROM
  DAOutcome 
WHERE 
  (
    
    (
      endDate IS NOT NULL 
      AND endDate >= current_date 
    ) 
    OR endDate IS NULL 
  ) 
  AND recordStatus = :recordStatus