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 304: FROM per_all_people_f peo,

300: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
301: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
302: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
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

Line 385: FROM per_all_people_f peo,

381: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
382: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
383: COUNT(DECODE(peo.per_information1,'6',DECODE(peo.sex,'F',1,NULL),'7',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_ifemale_emps
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

Line 467: FROM per_all_people_f peo,

463: COUNT(DECODE(peo.per_information1,'3',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_hfemale_emps,
464: COUNT(DECODE(peo.per_information1,'4',DECODE(peo.sex,'F',1,NULL),'5',DECODE(peo.sex,'F',1,NULL),NULL)) no_cons_afemale_emps,
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

Line 523: FROM per_all_people_f peo,

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

Line 577: FROM per_all_people_f peo,

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

Line 646: FROM per_all_people_f peo,

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

Line 714: per_all_people_f peo

710: FROM (
711: SELECT ass.location_id
712: FROM per_all_assignments_f ass,
713: hr_organization_units_v hou,
714: per_all_people_f peo
715: WHERE ass.organization_id = hou.organization_id
716: AND ass.person_id = peo.person_id
717: AND p_report_date between ass.effective_start_date and ass.effective_end_date
718: AND p_report_date between peo.effective_start_date and peo.effective_end_date