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 1930: FROM per_all_assignments_f paf

1926: l_c_estab_details c_estab_details%ROWTYPE;
1927:
1928: CURSOR c_estab_max IS -- find out IF over 50 people at location
1929: /* SELECT count('num_emps_at_location')
1930: FROM per_all_assignments_f paf
1931: WHERE paf.business_group_id = p_business_group_id
1932: AND paf.primary_flag = 'Y'
1933: AND paf.assignment_type = 'E'
1934: AND p_start_date >= paf.effective_start_date

Line 1948: FROM per_all_assignments_f ass,

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

Line 1981: from per_all_assignments_f ass1

1977: and peo.person_id = peo1.person_id
1978: and peo1.current_employee_flag = 'Y'
1979: )
1980: AND ass.effective_start_date = (select max(ass1.effective_start_date)
1981: from per_all_assignments_f ass1
1982: ,per_assignment_status_types ast --Added for bug##12616269
1983: where p_start_date <= ass1.effective_end_date
1984: and p_end_date >= ass1.effective_start_date
1985: and ass.person_id = ass1.person_id

Line 2046: per_all_assignments_f ass,

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

Line 2150: per_all_assignments_f ass,

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

Line 2238: per_all_assignments_f ass,

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