DBA Data[Home] [Help]

APPS.PER_EVS_MAG_REPORT dependencies on HR_ORGANIZATION_INFORMATION

Line 24: ,hr_organization_information hoi

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
28: AND paf.person_id = ppf.person_id

Line 58: ,hr_organization_information hoi

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))
62: and paa.assignment_id = paf.assignment_id