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