| Operation Details |  |
| Description: | Entity method to read cancellation reason code by case. |
| Sterotype: | ns |
| SQL | |
SELECT
cancelReasonCode
INTO
:cancelReasonCode
FROM
AppealCancellation
WHERE caseID = :caseID
AND cancelDateTime =
(
SELECT
MAX(cancelDateTime)
FROM
AppealCancellation
WHERE caseID = :caseID
)
|