SELECT
  concernRoleName
INTO
  :concernRoleName 
FROM
  ConcernRole,
  HearingParticipation,
  CaseParticipantRole 
WHERE HearingParticipation.hearingID = :hearingID 
  AND CaseParticipantRole.caseParticipantRoleID =HearingParticipation.caseParticipantRoleID 
  AND CaseParticipantRole.typeCode = :typeCode 
  AND CaseParticipantRole.participantRoleID =ConcernRole.CONCERNROLEID