APPS.PER_EEO_MAG_REPORT dependencies on PER_PEOPLE_F

Line 1926: from per_people_f peo1

1922: AND p_end_date >= job.date_from
1923: AND job.job_information1 is not NULL
1924: AND ass.job_id = job.job_id
1925: AND peo.effective_start_date = (select max(peo1.effective_start_date)
1926: from per_people_f peo1
1927: where p_start_date <= peo1.effective_end_date
1928: and p_end_date >= peo1.effective_start_date
1929: and peo.person_id = peo1.person_id
1930: and peo1.current_employee_flag = 'Y'

Line 1998: FROM per_people_f peo1

1994: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
1995: AND ass.job_id = job.job_id
1996: AND peo.effective_start_date =
1997: (SELECT MAX(peo1.effective_start_date)
1998: FROM per_people_f peo1
1999: WHERE p_start_date <= peo1.effective_end_date
2000: AND p_end_date >= peo1.effective_start_date
2001: AND peo.person_id = peo1.person_id
2002: AND peo1.current_employee_flag = 'Y'

Line 2072: FROM per_people_f peo1

2068: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
2069: AND ass.job_id = job.job_id
2070: AND peo.effective_start_date =
2071: (SELECT MAX(peo1.effective_start_date)
2072: FROM per_people_f peo1
2073: WHERE p_start_date <= peo1.effective_end_date
2074: AND p_end_date >= peo1.effective_start_date
2075: AND peo.person_id = peo1.person_id
2076: AND peo1.current_employee_flag = 'Y'

Line 2141: FROM per_people_f peo1

2137: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
2138: AND ass.job_id = job.job_id
2139: AND peo.effective_start_date =
2140: (SELECT MAX(peo1.effective_start_date)
2141: FROM per_people_f peo1
2142: WHERE p_start_date <= peo1.effective_end_date
2143: AND p_end_date >= peo1.effective_start_date
2144: AND peo.person_id = peo1.person_id
2145: AND peo1.current_employee_flag = 'Y'