Database SQL Operation: HearingServiceSupplier.searchInterpreterByHearingID
Description: | Returns the hearing service suppliers and types for the specified hearing. |
Sterotype: | nsmulti |
SELECT
HearingServiceSupplier.participatedCode,
HearingServiceSupplier.hearingServiceSupplierID,
HearingServiceSupplier.supplierType,
HearingServiceSupplier.supplierLinkID
INTO
:participatedCode,
:hearingServiceSupplierID,
:supplierType,
:supplierLinkID
FROM
HearingServiceSupplier
WHERE HearingServiceSupplier.hearingID = :hearingID
|