SELECT
  DISTINCT determinationDeliveryID,
  effectiveDate,
  status
INTO
  :determinationDeliveryID,
  :effectiveDate,
  :status 
FROM
  DeterminationDelivery 
WHERE DeterminationDelivery.assessmentCaseID = :assessmentCaseID 
  AND 
  (
    DeterminationDelivery.status = :status1 
    OR DeterminationDelivery.status = :status2 
  )