eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PER_PERUSEOX_XMLP_PKG dependencies on HR_LOOKUPS

Line 201: from hr_lookups

197: (
198: (peo.per_information1 is not null
199: and exists
200: (select null
201: from hr_lookups
202: where peo.per_information1 = lookup_code
203: and lookup_type = 'US_ETHNIC_GROUP'
204: )
205: )

Line 255: from hr_lookups

251: and report_date_end between job.date_from
252: and nvl(job.date_to, report_date_end)
253: and job.job_information1 in
254: (select lookup_code
255: from hr_lookups
256: where lookup_type = 'US_EEO1_JOB_CATEGORIES')
257: ;
258:
259: cursor c_person_name is

Line 272: from hr_lookups lup

268: ;
269:
270: cursor c_job_cat is
271: select nvl(jbt.name, 'Not Specified')||' '||nvl(lup.meaning,'') job_cat
272: from hr_lookups lup
273: ,per_all_assignments_f ass
274: ,per_jobs_vl job
275: ,per_jobs_tl jbt
276: where ass.person_id = person_id1

Line 296: from hr_lookups lup

292:
293: /* Commented for bug#11736960 starts
294: cursor c_eth_cat is
295: select nvl(lup.meaning, 'Not Specified') ethnic
296: from hr_lookups lup
297: ,per_all_people_f peo
298: where peo.person_id = person_id1
299: and peo.business_group_id = P_BUSINESS_GROUP_ID
300: and peo.per_information_category(+) = 'US'

Line 311: from hr_lookups lup

307: Commented for bug#11736960 ends */
308:
309: cursor c_emp_cat is
310: select nvl(lup.meaning, 'Not Specified') emp_cat
311: from hr_lookups lup
312: ,per_all_assignments_f ass
313: where ass.person_id = person_id1
314: and ass.business_group_id = P_BUSINESS_GROUP_ID
315: and ass.employment_category = lup.lookup_code(+)