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 293: per_jobs job,

289: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
290: FROM per_all_people_f peo,
291: per_all_assignments_f ass,
292: per_assignment_status_types ast,
293: per_jobs job,
294: hr_lookups hl
295: WHERE peo.person_id = ass.person_id
296: AND peo.current_employee_flag = 'Y'
297: AND hl.lookup_code = job.job_information1

Line 360: per_jobs job,

356: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
357: FROM per_all_people_f peo,
358: per_all_assignments_f ass,
359: per_assignment_status_types ast,
360: per_jobs job,
361: hr_lookups hl
362: WHERE peo.person_id = ass.person_id
363: AND peo.current_employee_flag = 'Y'
364: AND hl.lookup_code = job.job_information1

Line 427: per_jobs job,

423: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
424: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
425: FROM per_all_people_f peo,
426: per_all_assignments_f ass,
427: per_jobs job,
428: hr_lookups hl
429: WHERE peo.person_id = ass.person_id
430: AND peo.current_employee_flag = 'Y'
431: AND hl.lookup_code = job.job_information1

Line 480: per_jobs job,

476: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
477: FROM per_all_people_f peo,
478: per_all_assignments_f ass,
479: per_assignment_status_types ast,
480: per_jobs job,
481: hr_lookups hl,
482: per_people_extra_info pei
483: WHERE peo.person_id = ass.person_id
484: AND peo.per_information1 = '13'

Line 532: per_jobs job,

528: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
529: FROM per_all_people_f peo,
530: per_all_assignments_f ass,
531: per_assignment_status_types ast,
532: per_jobs job,
533: hr_lookups hl,
534: per_people_extra_info pei
535: WHERE peo.person_id = ass.person_id
536: AND peo.per_information1 = '13'

Line 598: per_jobs job,

594: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
595: count(decode(pei.pei_information5,'6',decode(peo.sex,'F',1,null),null)) no_tmraces_ifemale_emps
596: FROM per_all_people_f peo,
597: per_all_assignments_f ass,
598: per_jobs job,
599: hr_lookups hl,
600: per_people_extra_info pei
601: WHERE peo.person_id = ass.person_id
602: AND peo.per_information1 = '13'