APPS.PER_EVS_MAG_REPORT dependencies on PER_ALL_PEOPLE_F

Line 23: ,per_all_people_f ppf

19: ,'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
20:
21: FROM pay_assignment_actions paa
22: ,per_all_assignments_f paf
23: ,per_all_people_f ppf
24: ,hr_organization_information hoi
25:
26: WHERE paa.payroll_action_id = fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))
27: AND paa.assignment_id = paf.assignment_id

Line 36: FROM per_all_people_f ppf2

32: WHERE paf.person_id = paf2.person_id
33: AND paf2.primary_flag = 'Y'
34: )
35: AND ppf.effective_start_date = (SELECT max(ppf2.effective_start_date)
36: FROM per_all_people_f ppf2
37: WHERE ppf.person_id = ppf2.person_id
38: )
39: AND paa.tax_unit_id = hoi.organization_id(+)
40: AND hoi.org_information_context(+) = 'EVS Filing'

Line 57: ,per_all_people_f ppf

53: , 'MULTI_REQ_INDICATOR=P' ,nvl(hoi.org_information3,' ')
54: From
55: pay_assignment_actions paa
56: ,per_all_assignments_f paf
57: ,per_all_people_f ppf
58: ,hr_organization_information hoi
59: where
60: paa.payroll_action_id =
61: fnd_number.canonical_to_number(pay_mag_tape.internal_prm_values(3))

Line 72: from per_all_people_f ppf2

68: )
69: -- and ppf.effective_start_date = paf.effective_start_date
70: and ppf.effective_start_date =
71: (select max(ppf2.effective_start_date)
72: from per_all_people_f ppf2
73: where ppf.person_id = ppf2.person_id
74: )
75: and paa.tax_unit_id = hoi.organization_id(+)
76: and hoi.org_information_context(+) = 'EVS Filing'