SELECT
  DecisionRejection.decisionRejectionID,
  DecisionRejection.rejectionDate,
  DecisionRejection.reasonCode,
  DecisionRejection.userName,
  Users.fullName
INTO
  :decisionRejectionID,
  :date,
  :reasonCode,
  :userName,
  :userFullName 
FROM
  DecisionRejection,
  Users 
WHERE DecisionRejection.caseID = :caseID 
  AND DecisionRejection.userName = Users.userName