APPS.PER_EVS_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 163: FROM per_all_people_f ppf

159:
160: 'SELECT /*+ INDEX(hsck,HR_SOFT_CODING_KEYFLEX_PK),
161: INDEX(HR_ORGANIZATION_UNITS_PK,hou)*/
162: DISTINCT ppf.person_id
163: FROM per_all_people_f ppf
164: ,per_all_assignments_f paf
165: ,hr_soft_coding_keyflex hsck
166: ,hr_organization_units hou
167: ,hr_organization_information hoi

Line 194: from per_all_people_f ppf

190: /*
191: -- Bug: 5212175
192:
193: 'select distinct ppf.person_id
194: from per_all_people_f ppf
195: ,per_all_assignments_f paf
196: ,hr_soft_coding_keyflex hsck
197: ,hr_organization_units hou
198: ,hr_organization_information hoi

Line 339: from per_all_people_f ppf ,

335:
336: select /*+ index(hou,HR_ORGANIZATION_UNITS_FK1)*/
337: distinct paf.assignment_id,
338: hsck.segment1
339: from per_all_people_f ppf ,
340: per_all_assignments_f paf,
341: hr_soft_coding_keyflex hsck,
342: hr_all_organization_units hou,
343: hr_organization_information hoi,

Line 356: from per_all_people_f ppf2

352: and past.per_system_status = 'ACTIVE_ASSIGN'
353: and paf.person_id = ppf.person_id
354: and ppf.current_employee_flag = 'Y'
355: and ppf.effective_start_date = (select max(ppf2.effective_start_date)
356: from per_all_people_f ppf2
357: where ppf.person_id = ppf2.person_id
358: and ppf2.current_employee_flag = 'Y'
359: and ppf2.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
360: and ppf2.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')

Line 428: from per_all_people_f ppf

424: order by paf.assignment_id;
425: */
426: /* commented for bug# 5687781
427: select distinct paf.assignment_id, hsck.segment1
428: from per_all_people_f ppf
429: ,per_all_assignments_f paf
430: ,hr_soft_coding_keyflex hsck
431: ,hr_organization_units hou
432: ,hr_organization_information hoi

Line 445: from per_all_people_f ppf2

441: and past.per_system_status = 'ACTIVE_ASSIGN'
442: and paf.person_id = ppf.person_id
443: and ppf.current_employee_flag = 'Y'
444: and ppf.effective_start_date = (select max(ppf2.effective_start_date)
445: from per_all_people_f ppf2
446: where ppf.person_id = ppf2.person_id
447: and ppf2.current_employee_flag = 'Y'
448: and ppf2.effective_start_date <= to_date(g_end_date,'YYYY/MM/DD/')
449: and ppf2.effective_end_date >= to_date(g_start_date,'YYYY/MM/DD/')