EBS users managers query

Hi team,

I have task to add managers column for down query. I have found table per_all_people_f which can be joined with fnd_user table using this condition and PER_ALL_PEOPLE_F.person_id=applsys.fnd_user.employee_id and for supervisor data i can fetch via joining supervisor_id and employee_id.

I have tried to join like this way, but problem is that we are missing certain number of employees in PER_ALL_PEOPLE_F table. Is there any other table which i can query for them?

Query which i currently use:

SELECT 

 fu.user_name    "User name", frt.responsibility_name "Responsibility Name" ,