Query to find the HRBP Representative of an Employee in HCM Database
Find a 'HR Business Partner' of an Employee in HCM Database - to create a report on Employee and his/her 'HR Business Partner Representative' details.
I want to find the HRBP and Line Manager of an Employee and trigger them E-mail on his Last Working day. For this requirement, I am looking for a query to find the HRBP of an Employee. I have found the Line Manager but I couldn't able to find the HRBP of an employee. Please help. I'm leaving my incomplete query here.
Version (include the version you are using, if applicable):