Operation Details
Description: Reads interpreter details based on a case user role.
Sterotype: ns
SQL 
SELECT
  CaseUserRole.recordStatus,
  CaseUserRole.orgObjectLinkID,
  HearingServiceSupplier.participatedCode,
  HearingServiceSupplier.supplierType,
  HearingServiceSupplier.comments,
  HearingServiceSupplier.versionNo,
  CaseUserRole.versionNo
INTO
  :recordStatus,
  :orgObjectLinkID,
  :participatedCode,
  :supplierType,
  :comments,
  :supplierVersionNo,
  :caseUserVersionNo 
FROM
  HearingServiceSupplier,
  CaseUserRole 
WHERE HearingServiceSupplier.supplierLinkID = :supplierLinkID 
  AND HearingServiceSupplier.hearingID = :hearingID 
  AND CaseUserRole.caseUserRoleID = HearingServiceSupplier.supplierLinkID