SQL Join of HCM and UDT tables together

Summary

SQL Join of HCM and UDT tables together

Content

Hello:

How can i create a SQL join of HCM and UDT tables together in a BIP report?

Can i and do i have to use this package statement?

select FF_USER_TABLES_PKG.GET_TABLE_VALUE_ENT(1, SYSDATE, 'XXHR_UDT', 'COLUMN1', ROW_VALUE) from dual

I need to join 'Person Number to retrieve 'Legal Employer/lCompany' where both Employee and Company are UDT column values.

For instance to join 

SELECT *

FROM UDT u,

           PER_ALL_PEOPLE_F papf

WHERE papf.person_id = UDT.Row_Value ?   - OR- WHERE papf.person_id = UDT.'Column Name'?