How to fetch Recruiter Name and Hiring Manager Name on the basis of Position.

Summary:

I need to fetch the Incumbent Name, Hiring Manager Name and Recruiter name on the basis of Position. It needs to be joined with HR_ALL_POSITIONS table.
Can anyone help me with the SQL Query. My main table is HR_All_Positions_F.

Content (please ensure you mask any confidential information):

I have used these tables but I am getting the incumbent name, hiring manager and recruiter same.

PER_PERSON_NAMES_F PPNF,
PER_PERSONS PP,
PER_PERSON_NAMES_F PPNF1,
PER_PERSONS PP1

IRC_REQUISITIONS_B IRB

HR_ALL_POSITIONS_F HAPF

PER_ALL_ASSIGNMENTS_M PAAM