Operation Details
Description: <P class=MsoNormal style="MARGIN: 0cm 0cm 0pt"><SPAN lang=EN-IE style="mso-ansi-language: EN-IE"><FONT size=3><FONT face="Times New Roman">Counts the number of active Appeal cases where the participant has a role of ‘Appellant’ or ‘Respondent’.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p></o:p></FONT></FONT></SPAN></P>
Sterotype: ns
SQL 
SELECT 
COUNT(*)

INTO
:numOfRecords

FROM 
CaseParticipantRole,
CaseHeader

WHERE 
CaseParticipantRole.participantRoleID = :participantRoleID AND 
(
CaseParticipantRole.typeCode = :appellantParticipantType OR 
CaseParticipantRole.typeCode = :respondentParticipantType 
) AND
CaseParticipantRole.recordStatus = :recordStatus AND
CaseHeader.caseID = CaseParticipantRole.caseID AND
CaseHeader.caseTypeCode = :appealCaseType