Operation Details
Description: Search Case Appeals by Case ID and Status.
Sterotype: nsmulti
SQL 
SELECT
  appealID,
  caseID,
  serviceSupplierID,
  contact,
  typeCode,
  startDate,
  endDate,
  notificationDate,
  outcomeCode,
  statusCode,
  documentRefNo,
  expectCompleteDate,
  reasonText,
  fileReferenceNo,
  versionNo
INTO
  :appealID,
  :caseID,
  :serviceSupplierID,
  :contact,
  :typeCode,
  :startDate,
  :endDate,
  :notificationDate,
  :outcomeCode,
  :statusCode,
  :documentRefNo,
  :expectCompleteDate,
  :reasonText,
  :fileReferenceNo,
  :versionNo 
FROM
  CaseAppeal 
WHERE CaseAppeal.caseID = :caseID 
  AND 
  (
    CaseAppeal.statusCode = :statusCode1 
    OR CaseAppeal.statusCode = :statusCode2 
  )