APPS.PER_EEO_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 1916: per_all_people_f peo,

1912: ); */
1913: -- The above query is replace with the following query for the bug# 6216140
1914: SELECT count(peo.person_id)
1915: FROM per_all_assignments_f ass,
1916: per_all_people_f peo,
1917: per_jobs_vl job
1918: WHERE peo.person_id = ass.person_id
1919: AND peo.per_information1 is not NULL
1920: AND job.job_information_category = 'US'

Line 1982: FROM per_all_people_f peo,

1978: COUNT(DECODE(peo.per_information1,'6',1)) c_ifemale,
1979: COUNT(DECODE(peo.per_information1,'13',1)) c_tmracesfemale,
1980: count(peo.person_id) "c_total_cat",
1981: hrl.lookup_code lookup_code
1982: FROM per_all_people_f peo,
1983: per_all_assignments_f ass,
1984: per_jobs_vl job,
1985: hr_lookups hrl,
1986: per_gen_hierarchy_nodes pgn_est

Line 2056: FROM per_all_people_f peo,

2052: COUNT(DECODE(peo.per_information1,'4',1)) c_amale,
2053: COUNT(DECODE(peo.per_information1,'6',1)) c_imale,
2054: COUNT(DECODE(peo.per_information1,'13',1)) c_tmracesmale,
2055: hrl.lookup_code lookup_code
2056: FROM per_all_people_f peo,
2057: per_all_assignments_f ass,
2058: per_jobs_vl job,
2059: hr_lookups hrl,
2060: per_gen_hierarchy_nodes pgn_est

Line 2125: FROM per_all_people_f peo,

2121: -- Updated CURSOR BUG4583250
2122: SELECT
2123: count('all_birds_and_blokes_in_job') c_mf,
2124: hrl.lookup_code lookup_code
2125: FROM per_all_people_f peo,
2126: per_all_assignments_f ass,
2127: per_jobs_vl job,
2128: hr_lookups hrl,
2129: per_gen_hierarchy_nodes pgn_est