Operation Details
Description: This counts all active users for the specified hearing with the given userName.
Sterotype: ns
SQL 
SELECT
  COUNT(hearingUserRoleID)
INTO
  :numberOfRecords 
FROM
  HearingUserRole,
  CaseUserRole 
WHERE hearingID = :hearingID 
  AND HearingUserRole.caseUserRoleID = CaseUserRole.caseUserRoleID 
  AND orgObjectLinkID = :orgObjectLinkID 
  AND recordStatus = :recordStatus