Operation Details
Description: Returns the latest appealed case rejection reason code given the appeal relationship id.
Sterotype: ns
SQL 
SELECT
  reasonCode
INTO
  :reasonCode 
FROM
  AppealedCaseRejection 
WHERE appealRelationshipID = :appealRelationshipID 
  AND rejectionDate = ( 
  SELECT
    MAX(rejectionDate) 
  FROM
    AppealedCaseRejection 
  WHERE appealRelationshipID = :appealRelationshipID 
  )