Operation Details
Description: Retrieve all service suppliers of a specified status for a hearing.
Sterotype: nsmulti
SQL 
SELECT
  HearingServiceSupplier.hearingServiceSupplierID,
  HearingServiceSupplier.hearingID,
  HearingServiceSupplier.supplierLinkID,
  HearingServiceSupplier.supplierType
INTO
  :hearingServiceSupplierID,
  :hearingID,
  :supplierLinkID,
  :supplierType 
FROM
  HearingServiceSupplier 
WHERE HearingServiceSupplier.hearingID = :hearingID