DBA Data[Home] [Help]

APPS.PAY_ZA_IRP5_MAGTAPE_PKG dependencies on PAY_ALL_PAYROLLS_F

Line 116: pay_all_payrolls_f papf,

112: 'PAYROLL_ID=C', pef.payroll_id,
113: 'SOURCE_TEXT=C', nvl(faidn.context,'To Be Advised')
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,

Line 158: from pay_all_payrolls_f papf2

154: and papf.payroll_id = pef.payroll_id
155: and papf.effective_start_date =
156: (
157: select max(papf2.effective_start_date)
158: from pay_all_payrolls_f papf2
159: where papf2.effective_start_date <= ppa.effective_date
160: and papf2.payroll_id = pef.payroll_id
161: )
162: and scl.soft_coding_keyflex_id (+) = papf.soft_coding_keyflex_id