Operation Details
Description: Returns the number of active hearing user roles for a hearing with the specified participation.
Sterotype: ns
SQL 
SELECT
  COUNT(hearingUserRoleID)
INTO
  :numberOfRecords 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE HearingUserRole.hearingID = :hearingID 
  AND HearingUserRole.participatedCode = :participatedCode 
  AND HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID 
  AND CaseUserRole.recordStatus = :recordStatus