DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_PRE_PAYMENTS

Line 97: ,pay_pre_payments ppp

93: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
94: AND EXISTS (
95: SELECT 1
96: FROM pay_assignment_actions pas
97: ,pay_pre_payments ppp
98: WHERE pas.payroll_action_id = ppa.payroll_action_id
99: AND ppp.pre_payment_id = pas.pre_payment_id
100: AND ppp.value > 0 );
101:

Line 164: ,pay_pre_payments ppp

160: (
161: SELECT 1
162: FROM
163: pay_assignment_actions pas
164: ,pay_pre_payments ppp
165: ,per_all_assignments_f paaf
166: ,pay_all_payrolls_f ppf
167: WHERE pas.payroll_action_id = ppa.payroll_action_id
168: AND ppp.pre_payment_id = pas.pre_payment_id

Line 227: ,pay_pre_payments ppp

223: ,min(pef.NATIONAL_IDENTIFIER)
224: FROM per_all_assignments_f paf
225: ,per_all_people_f pef
226: ,pay_all_payrolls_f ppf
227: ,pay_pre_payments ppp
228: ,pay_assignment_actions paa
229: ,pay_payroll_actions ppa
230: ,pay_personal_payment_methods_f ppmf
231: ,pay_external_accounts pea