DBA Data[Home] [Help]

APPS.PER_US_VETS_100A_SINGLE_PKG dependencies on HR_LOOKUPS

Line 155: FROM hr_lookups

151: upper(rpad(meaning,26,'.'))||lookup_code cons_job_category_name,
152: lookup_code cons_job_category_code,
153: decode(lookup_code,'8','LABORERS/HELPERS'
154: ,upper(meaning)) job_category_name
155: FROM hr_lookups
156: WHERE lookup_type = 'US_EEO1_JOB_CATEGORIES'
157: ORDER BY diplay_order ;
158:
159: --Variable Declaration