APPS.PER_EEO_MAG_REPORT dependencies on PER_PEOPLE_F

Line 1974: from per_people_f peo1

1970: AND p_end_date >= job.date_from
1971: AND job.job_information1 is not NULL
1972: AND ass.job_id = job.job_id
1973: AND peo.effective_start_date = (select max(peo1.effective_start_date)
1974: from per_people_f peo1
1975: where p_start_date <= peo1.effective_end_date
1976: and p_end_date >= peo1.effective_start_date
1977: and peo.person_id = peo1.person_id
1978: and peo1.current_employee_flag = 'Y'

Line 2076: FROM per_people_f peo1

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

Line 2180: FROM per_people_f peo1

2176: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
2177: AND ass.job_id = job.job_id
2178: AND peo.effective_start_date =
2179: (SELECT MAX(peo1.effective_start_date)
2180: FROM per_people_f peo1
2181: WHERE p_start_date <= peo1.effective_end_date
2182: AND p_end_date >= peo1.effective_start_date
2183: AND peo.person_id = peo1.person_id
2184: AND peo1.current_employee_flag = 'Y'

Line 2255: FROM per_people_f peo1

2251: AND hrl.lookup_type = 'US_EEO1_JOB_CATEGORIES'
2252: AND ass.job_id = job.job_id
2253: AND peo.effective_start_date =
2254: (SELECT MAX(peo1.effective_start_date)
2255: FROM per_people_f peo1
2256: WHERE p_start_date <= peo1.effective_end_date
2257: AND p_end_date >= peo1.effective_start_date
2258: AND peo.person_id = peo1.person_id
2259: AND peo1.current_employee_flag = 'Y'