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_ALL_PEOPLE_F

Line 290: FROM per_all_people_f peo,

286: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
287: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
288: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
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

Line 357: FROM per_all_people_f peo,

353: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
354: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
355: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
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

Line 425: FROM per_all_people_f peo,

421: COUNT(DECODE(peo.per_information1,'2',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_bfemale_emps,
422: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
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

Line 477: FROM per_all_people_f peo,

473: count(decode(pei.pei_information5,'2',decode(peo.sex,'F',1,null),null)) no_tmraces_bfemale_emps,
474: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
475: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
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,

Line 529: FROM per_all_people_f peo,

525: count(decode(pei.pei_information5,'2',decode(peo.sex,'F',1,null),null)) no_tmraces_bfemale_emps,
526: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
527: count(decode(pei.pei_information5,'4',decode(peo.sex,'F',1,null),'5',decode(peo.sex,'F',1,null),null)) no_tmraces_afemale_emps,
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,

Line 596: FROM per_all_people_f peo,

592: count(decode(pei.pei_information5,'2',decode(peo.sex,'F',1,null),null)) no_tmraces_bfemale_emps,
593: count(decode(pei.pei_information5,'3',decode(peo.sex,'F',1,null),'9',decode(peo.sex,'F',1,null),null)) no_tmraces_hfemale_emps,
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

Line 662: per_all_people_f peo

658: FROM (
659: SELECT ass.location_id
660: FROM per_all_assignments_f ass,
661: hr_organization_units_v hou,
662: per_all_people_f peo
663: WHERE ass.organization_id = hou.organization_id
664: AND ass.person_id = peo.person_id
665: AND p_report_date between ass.effective_start_date and ass.effective_end_date
666: AND p_report_date between peo.effective_start_date and peo.effective_end_date