Operation Details
Description: Count the number of active participant roles as appellant on appeal case.
Sterotype: ns
SQL 
SELECT
  count(*)
INTO
  :numberOfRecords 
FROM
  Appeal,
  CaseParticipantRole 
WHERE Appeal.appealID = :appealID 
  AND Appeal.caseID =CaseParticipantRole.caseID 
  AND CaseParticipantRole.participantRoleID = :participantRoleID 
  AND CaseParticipantRole.typecode = :roleTypeCode 
  AND 
  (
    CaseParticipantRole.toDate IS NULL 
    OR CaseParticipantRole.toDate >= :date 
  )