SELECT
  participantRoleID,
  CaseParticipantRole.caseParticipantRoleID
INTO
  :participantRoleID,
  :caseParticipantRoleID 
FROM
  HearingParticipation,
  CaseParticipantRole 
WHERE HearingParticipation.hearingID = :hearingID 
  AND CaseParticipantRole.caseParticipantRoleID =HearingParticipation.caseParticipantRoleID 
  AND CaseParticipantRole.typeCode = :typeCode 
  AND CaseParticipantRole.recordStatus = :recordStatus 
  AND CaseParticipantRole.caseID = :caseID