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_US_EEO5_PKG dependencies on PER_JOBS

Line 307: per_jobs job,

303: Commented for bug#11736960 ends */
304: FROM per_all_people_f peo,
305: per_all_assignments_f ass,
306: per_assignment_status_types ast,
307: per_jobs job,
308: hr_lookups hl
309: WHERE peo.person_id = ass.person_id
310: AND peo.current_employee_flag = 'Y'
311: AND hl.lookup_code = job.job_information1

Line 388: per_jobs job,

384: Commented for bug#11736960 ends */
385: FROM per_all_people_f peo,
386: per_all_assignments_f ass,
387: per_assignment_status_types ast,
388: per_jobs job,
389: hr_lookups hl
390: WHERE peo.person_id = ass.person_id
391: AND peo.current_employee_flag = 'Y'
392: AND hl.lookup_code = job.job_information1

Line 469: per_jobs job,

465: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
466: Commented for bug#11736960 ends */
467: FROM per_all_people_f peo,
468: per_all_assignments_f ass,
469: per_jobs job,
470: hr_lookups hl
471: WHERE peo.person_id = ass.person_id
472: AND peo.current_employee_flag = 'Y'
473: AND hl.lookup_code = job.job_information1

Line 526: per_jobs job,

522: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
523: FROM per_all_people_f peo,
524: per_all_assignments_f ass,
525: per_assignment_status_types ast,
526: per_jobs job,
527: hr_lookups hl,
528: per_people_extra_info pei
529: WHERE peo.person_id = ass.person_id
530: AND peo.per_information1 = '13'

Line 580: per_jobs job,

576: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
577: FROM per_all_people_f peo,
578: per_all_assignments_f ass,
579: per_assignment_status_types ast,
580: per_jobs job,
581: hr_lookups hl,
582: per_people_extra_info pei
583: WHERE peo.person_id = ass.person_id
584: AND peo.per_information1 = '13'

Line 648: per_jobs job,

644: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
645: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
646: FROM per_all_people_f peo,
647: per_all_assignments_f ass,
648: per_jobs job,
649: hr_lookups hl,
650: per_people_extra_info pei
651: WHERE peo.person_id = ass.person_id
652: AND peo.per_information1 = '13'