Can anyone advise on a PL/SQL API to get either the Person ID or the Person Name from an Employee ID?
E.g. for an individual with Employee ID = 12345, Person ID = “JSMITH” and Person Name = “John Smith”, is there any API to get either JSMITH or John Smith from 12345?
Best answer by COVJAMIEB
Hello. You could try,
Company_Person_API.Get_Person_Id(company_id, emp_no) OR
Company_Person_API.Get_Person(company_id, emp_no)
+11Hello. You could try,
Company_Person_API.Get_Person_Id(company_id, emp_no) OR
Company_Person_API.Get_Person(company_id, emp_no)
+5Hello,The person ID result will be returned from the above functions. The name will be returned when you try the following operation.
PERS_API.Get_Name(COMPANY_PERSON_API.Get_Person_ID(company_id,emp_no))
+9Hi,
But that would lead to nothing:
Now what is the CPA?
It stands for the View COMPANY_PERSON_ALL.
The Join looks like this:
The CPA View is under the following objects:
HTH
BR
Michael
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
