Operation Details
Description: Reads summary details of the decision rejection.
Sterotype: ns
SQL 
SELECT
  DecisionRejection.rejectionDate,
  DecisionRejection.reasonCode,
  DecisionRejection.reasonText,
  DecisionRejection.userName,
  Users.fullName
INTO
  :date,
  :reasonCode,
  :reasonText,
  :userName,
  :userFullName 
FROM
  DecisionRejection,
  Users 
WHERE DecisionRejection.decisionRejectionID = :decisionRejectionID 
  AND DecisionRejection.userName = Users.userName