Query to fetch HR Representative person

Hello All,

Need to fetch data either by using BIP or OTBI, HR Representatives associated to a Person.

I am able to fetch AOR's Associated to an Employee, But the requirement is to get people associated with that AOR.

Below Query Fetches AOR Associated :

Select
pn.display_name,
pa11.persoN_number,
asg.assignment_number,
aor.*
from
per_asg_responsibilities aor
join peR_persoN_names_f pn on aor.person_id = pn.persoN_id
join per_all_people_f pa11 on aor.person_id = pa11.person_id
join per_all_assignments_m asg on aor.person_id = asg.person_id
where