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