Skip to main content

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?

Hello. You could try,

Company_Person_API.Get_Person_Id(company_id, emp_no) OR

Company_Person_API.Get_Person(company_id, emp_no)

 

Perfect, tvm!

Hello,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))

Hi,
 

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

Terms & ConditionsCookie settingsAccessibility statement