SELECT
  HearingServiceSupplier.hearingServiceSupplierID,
  HearingServiceSupplier.versionNo,
  CaseParticipantRole.caseParticipantRoleID,
  CaseParticipantRole.participantRoleID,
  CaseUserRole.caseUserRoleID
INTO
  :hearingServiceSupplierID,
  :versionNo,
  :caseParticipantRoleID,
  :participantRoleID,
  :caseUserRoleID 
FROM
  HearingServiceSupplier,
  CaseParticipantRole,
  CaseUserRole 
WHERE HearingServiceSupplier.hearingID = :hearingID 
  AND 
  (
    
    (
      HearingServiceSupplier.supplierLinkID = CaseParticipantRole.caseParticipantRoleID 
      AND CaseParticipantRole.recordStatus = :recordStatus 
      AND CaseParticipantRole.typeCode = :typeCode 
    ) 
    OR 
    (
      HearingServiceSupplier.supplierLinkID = CaseUserRole.caseUserRoleID 
      AND CaseUserRole.recordStatus = :recordStatus 
      AND CaseUserRole.typeCode = :typeCode 
    ) 
  )