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_JOBS_VL

Line 1950: per_jobs_vl job

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
1954: AND EXISTS (SELECT 'X'

Line 2047: per_jobs_vl job,

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
2050: WHERE peo.person_id = ass.person_id
2051: --AND peo.per_information1 is not NULL commented for fix for #12616269

Line 2151: per_jobs_vl job,

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
2154: WHERE peo.person_id = ass.person_id
2155: --AND peo.per_information1 is not NULL commented for fix for #12616269

Line 2239: per_jobs_vl job,

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
2242: WHERE peo.person_id = ass.person_id
2243: -- Modified to add function call per_us_hr_utility_pkg.derive_alien_ethnic_origin instead of peo.per_information1