APPS.PER_EVS_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 32: ,per_all_people_f ppf

28: ,'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
29:
30: FROM pay_assignment_actions paa
31: ,per_all_assignments_f paf
32: ,per_all_people_f ppf
33: ,hr_organization_information hoi
34:
35: WHERE paa.payroll_action_id = fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
36: AND paa.assignment_id = paf.assignment_id

Line 45: FROM per_all_people_f ppf2

41: WHERE paf.person_id = paf2.person_id
42: AND paf2.primary_flag = 'Y'
43: )
44: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
45: FROM per_all_people_f ppf2
46: WHERE ppf.person_id = ppf2.person_id
47: )
48: AND paa.tax_unit_id = hoi.organization_id(+)
49: AND hoi.org_information_context(+) = 'EVS Filing'

Line 66: ,per_all_people_f ppf

62: , 'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
63: From
64: pay_assignment_actions paa
65: ,per_all_assignments_f paf
66: ,per_all_people_f ppf
67: ,hr_organization_information hoi
68: where
69: paa.payroll_action_id =
70: fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))

Line 81: from per_all_people_f ppf2

77: )
78: -- and ppf.effective_start_date = paf.effective_start_date
79: and ppf.effective_start_date =
80: (select max(ppf2.effective_start_date)
81: from per_all_people_f ppf2
82: where ppf.person_id = ppf2.person_id
83: )
84: and paa.tax_unit_id = hoi.organization_id(+)
85: and hoi.org_information_context(+) = 'EVS Filing'