DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on PER_PEOPLE_F

Line 118: per_people_f ppf,

114: from pay_payroll_actions ppa,
115: hr_soft_coding_keyflex scl,
116: pay_all_payrolls_f papf,
117: per_assignments_f pef,
118: per_people_f ppf,
119: pay_assignment_actions paa,
120: per_assignment_extra_info paei,
121: ff_archive_items fai,
122: ff_archive_item_contexts faidn,

Line 150: from per_people_f ppf2

146: )
147: and ppf.effective_start_date =
148: (
149: select max(ppf2.effective_start_date)
150: from per_people_f ppf2
151: where ppf2.effective_start_date <= ppa.effective_date
152: and ppf2.person_id = ppf.person_id
153: )
154: and papf.payroll_id = pef.payroll_id