APPS.PER_EEO_MAG_REPORT dependencies on PER_ALL_ASSIGNMENTS_F

Line 288: FROM per_all_assignments_f paf

284:
285: -- find out if over 100 people IN company for 13
286: CURSOR c_max IS
287: SELECT count('num_emps')
288: FROM per_all_assignments_f paf
289: WHERE paf.business_group_id = p_business_group_id
290: AND paf.primary_flag = 'Y'
291: AND paf.assignment_type = 'E'
292: AND p_start_date > paf.effective_start_date

Line 1897: FROM per_all_assignments_f paf

1893: l_c_estab_details c_estab_details%ROWTYPE;
1894:
1895: CURSOR c_estab_max IS -- find out IF over 50 people at location
1896: /* SELECT count('num_emps_at_location')
1897: FROM per_all_assignments_f paf
1898: WHERE paf.business_group_id = p_business_group_id
1899: AND paf.primary_flag = 'Y'
1900: AND paf.assignment_type = 'E'
1901: AND p_start_date >= paf.effective_start_date

Line 1915: FROM per_all_assignments_f ass,

1911: AND pgn.node_type IN ('EST','LOC')
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

Line 1933: from per_all_assignments_f ass1

1929: and peo.person_id = peo1.person_id
1930: and peo1.current_employee_flag = 'Y'
1931: )
1932: AND ass.effective_start_date = (select max(ass1.effective_start_date)
1933: from per_all_assignments_f ass1
1934: where p_start_date <= ass1.effective_end_date
1935: and p_end_date >= ass1.effective_start_date
1936: and ass.person_id = ass1.person_id
1937: and ass1.assignment_type = 'E'

Line 1983: per_all_assignments_f ass,

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
1987: WHERE peo.person_id = ass.person_id

Line 2057: per_all_assignments_f ass,

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
2061: WHERE peo.person_id = ass.person_id

Line 2126: per_all_assignments_f ass,

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
2130: WHERE peo.person_id = ass.person_id