Operation Details
Description: Entity method to read the details of a canceled hearing case.
Sterotype: ns
SQL 
SELECT
  appealCancellationID,
  caseID,
  cancelUserName,
  fullName,
  cancelReasonText,
  cancelReasonCode,
  cancelDateTime,
  AppealCancellation.versionNo
INTO
  :appealCancellationID,
  :caseID,
  :cancelUserName,
  :cancelUserFullName,
  :cancelReasonText,
  :cancelReasonCode,
  :cancelDateTime,
  :versionNo 
FROM
  AppealCancellation,
  Users 
WHERE AppealCancellation.caseID = :caseID 
  AND AppealCancellation.cancelUserName = Users.userName