How to fetch Recruiter Name and Hiring Manager Name on the basis of Position. — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!