DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_PRE_PAYMENTS

Line 589: ,pay_pre_payments ppp

585: (
586: SELECT 1
587: FROM
588: pay_assignment_actions pas
589: ,pay_pre_payments ppp
590: ,per_all_assignments_f paaf
591: ,pay_all_payrolls_f ppf
592: WHERE pas.payroll_action_id = ppa.payroll_action_id
593: AND ppp.pre_payment_id = pas.pre_payment_id

Line 617: ,pay_pre_payments ppp

613: SUM(ppp.value*100) employer_sum, 1 record_count
614: FROM per_all_assignments_f paf
615: ,per_all_people_f pef
616: ,pay_all_payrolls_f ppf
617: ,pay_pre_payments ppp
618: ,pay_assignment_actions paa
619: ,pay_payroll_actions ppa
620: ,pay_personal_payment_methods_f ppmf
621: ,pay_external_accounts pea