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