Operation Details
Description: Counts active caseUserRole records based on hearing|D, typeCode, and recordStatus (active).
Sterotype: ns
SQL 
SELECT
  COUNT(hearingUserRoleID)
INTO
  :numberOfRecords 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingID = :hearingID 
  AND CaseUserRole.caseUserRoleID = HearingUserRole.caseUserRoleID 
  AND typeCode = :typeCode 
  AND recordStatus = :recordStatus