Operation Details
Description: Returns the count of active appeal cases of a specified appeal type for the specified participant in a specified role.
Sterotype: ns
SQL 
SELECT
  COUNT(*)
INTO
  :numberOfRecords 
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