Operation Details
Description: Reads interpreter details based on a case participant role.
Sterotype: ns
SQL 
SELECT
  CaseParticipantRole.recordStatus,
  HearingServiceSupplier.participatedCode,
  HearingServiceSupplier.supplierType,
  HearingServiceSupplier.comments,
  ConcernRole.concernRoleName,
  HearingServiceSupplier.versionNo,
  CaseParticipantRole.versionNo
INTO
  :recordStatus,
  :participatedCode,
  :supplierType,
  :comments,
  :concernRoleName,
  :supplierVersionNo,
  :caseParticipantVersionNo 
FROM
  HearingServiceSupplier,
  CaseParticipantRole,
  ConcernRole 
WHERE HearingServiceSupplier.supplierLinkID = :supplierLinkID 
  AND HearingServiceSupplier.hearingID = :hearingID 
  AND CaseParticipantRole.caseParticipantRoleID = HearingServiceSupplier.supplierLinkID 
  AND ConcernRole.concernRoleID = CaseParticipantRole.participantRoleID