APPS.PER_US_VETS_100A_CONS_PKG dependencies on HR_LOOKUPS

Line 138: FROM hr_lookups

134: upper(rpad(meaning,26,'.'))||lookup_code cons_job_category_name,
135: lookup_code cons_job_category_code,
136: decode(lookup_code,'8','LABORERS/HELPERS'
137: ,upper(meaning)) job_category_name
138: FROM hr_lookups
139: WHERE lookup_type = 'US_EEO1_JOB_CATEGORIES'
140: ORDER BY diplay_order ;
141:
142: cursor c_est_entity(p_state in varchar2) is

Line 1429: hr_lookups

1425: select
1426: meaning
1427: into l_state_meaning
1428: from
1429: hr_lookups
1430: where
1431: lookup_type = 'US_STATE'
1432: and lookup_code = l_state;
1433: