Operation Details
Description: Returns the details for all user type service suppliers for the specified hearingID.
Sterotype: nsmulti
SQL 
SELECT
  recordStatus,
  participatedCode,
  CaseUserRole.orgObjectLinkID,
  typeCode
INTO
  :recordStatus,
  :participatedCode,
  :orgObjectLinkID,
  :typeCode 
FROM
  HearingServiceSupplier,
  CaseUserRole 
WHERE hearingID = :hearingID 
  AND supplierType = :supplierType 
  AND supplierLinkID = caseUserRoleID