Operation Details
Description: Returns the list of active appeal cases of a specified appeal type for the specified participant in a specified role.
Sterotype: nsmulti
SQL 
SELECT
  CaseHeader.caseReference,
  Appeal.caseID,
  CaseHeader.ownerOrgObjectLinkID,
  Appeal.deadlineDate,
  CaseHeader.receivedDate,
  CaseHeader.statusCode,
  Appeal.versionNo
INTO
  :caseReference,
  :caseID,
  :ownerOrgObjectLinkID,
  :deadlineDate,
  :receivedDate,
  :status,
  :appealVersionNo 
FROM
  Appeal,
  CaseHeader,
  CaseParticipantRole 
WHERE Appeal.appealTypeCode = :appealTypeCode 
  AND CaseParticipantRole.participantRoleID = :participantRoleID 
  AND CaseParticipantRole.typeCode = :caseParticipantRoleTypeCode 
  AND 
  (
    CaseHeader.statusCode = :activeStatusCode 
    OR CaseHeader.statusCode = :openStatusCode 
    OR CaseHeader.statusCode = :approvedStatusCode 
  ) 
  AND Appeal.caseID = CaseHeader.caseID 
  AND CaseParticipantRole.caseID = CaseHeader.caseID