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_EEO_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 1949: per_all_people_f peo,

1945: ); */
1946: -- The above query is replace with the following query for the bug# 6216140
1947: SELECT count(peo.person_id)
1948: FROM per_all_assignments_f ass,
1949: per_all_people_f peo,
1950: per_jobs_vl job
1951: WHERE peo.person_id = ass.person_id
1952: --AND peo.per_information1 is not NULL commented for fix for #12616269
1953: -- Added for fix for #12616269

Line 2045: FROM per_all_people_f peo,

2041: COUNT(DECODE(peo.per_information1,'13',1)) c_tmracesfemale,
2042: Commented for fix of #12616269 */
2043: count(peo.person_id) "c_total_cat",
2044: hrl.lookup_code lookup_code
2045: FROM per_all_people_f peo,
2046: per_all_assignments_f ass,
2047: per_jobs_vl job,
2048: hr_lookups hrl,
2049: per_gen_hierarchy_nodes pgn_est

Line 2149: FROM per_all_people_f peo,

2145: COUNT(DECODE(peo.per_information1,'6',1)) c_imale,
2146: COUNT(DECODE(peo.per_information1,'13',1)) c_tmracesmale,
2147: Commented for fix of #12616269 */
2148: hrl.lookup_code lookup_code
2149: FROM per_all_people_f peo,
2150: per_all_assignments_f ass,
2151: per_jobs_vl job,
2152: hr_lookups hrl,
2153: per_gen_hierarchy_nodes pgn_est

Line 2237: FROM per_all_people_f peo,

2233: -- Updated CURSOR BUG4583250
2234: SELECT
2235: count('all_birds_and_blokes_in_job') c_mf,
2236: hrl.lookup_code lookup_code
2237: FROM per_all_people_f peo,
2238: per_all_assignments_f ass,
2239: per_jobs_vl job,
2240: hr_lookups hrl,
2241: per_gen_hierarchy_nodes pgn_est