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 1917: per_jobs_vl job

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'
1921: AND p_start_date <= nvl(job.date_to,p_end_date )

Line 1984: per_jobs_vl job,

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
1987: WHERE peo.person_id = ass.person_id
1988: AND peo.per_information1 IS not NULL

Line 2058: per_jobs_vl job,

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
2061: WHERE peo.person_id = ass.person_id
2062: AND peo.per_information1 IS NOT NULL

Line 2127: per_jobs_vl job,

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
2130: WHERE peo.person_id = ass.person_id
2131: AND peo.per_information1 IN ('1','2','3','4','5','6','13') --BUG4410003