Forget about that PUI - the FND tables will give you everything that you need.
select fdu.application_column_name
,fdu.end_user_column_name
from fnd_descr_flex_column_usages fdu
,fnd_descriptive_flexs fdf
where fdu.descriptive_flexfield_name = fdf.descriptive_flexfield_name
and fdf.application_table_name = 'PER_ALL_ASSIGNMENTS_F'
order by 1,2
APPLICATION_COLUMN_NAME END_USER_COLUMN_NAME
------------------------------ ------------------------------
ASS_ATTRIBUTE1 Union Seniority Date
ASS_ATTRIBUTE2 Acquisition Company
2 rows selected.
It even works for Job information:
select fdu.application_column_name
,fdu.end_user_column_name
from fnd_descr_flex_column_usages fdu
,fnd_descriptive_flexs fdf
where fdu.descriptive_flexfield_name = fdf.descriptive_flexfield_name
and fdf.application_table_name = 'PER_JOBS'
and descriptive_flex_context_code = 'US'
order by 1,2
APPLICATION_COLUMN_NAME END_USER_COLUMN_NAME
------------------------------ ------------------------------
JOB_INFORMATION1 EEO Category
JOB_INFORMATION2 Survey Benchmark
JOB_INFORMATION3 FLSA Code
JOB_INFORMATION4 Job Group
JOB_INFORMATION5 Line of Progression
JOB_INFORMATION6 Salary Code
JOB_INFORMATION7 EEO Function
JOB_INFORMATION8 IPEDS Category
8 rows selected.
/*CL*/
