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