DBA Data[Home] [Help]

APPS.PAY_IE_PAYFILE_SEPA dependencies on PAY_PRE_PAYMENTS

Line 82: ,pay_pre_payments ppp

78: AND hou.business_group_id = ppa.business_group_id --15971893
79: AND hou.organization_id = ppa.business_group_id --15971893
80: AND EXISTS (SELECT 1
81: FROM pay_assignment_actions pas
82: ,pay_pre_payments ppp
83: WHERE pas.payroll_action_id = ppa.payroll_action_id
84: AND ppp.pre_payment_id = pas.pre_payment_id
85: AND ppp.value > 0 );
86:

Line 139: ,pay_pre_payments ppp

135: EXISTS
136: (
137: SELECT 1
138: FROM pay_assignment_actions pas
139: ,pay_pre_payments ppp
140: ,per_all_assignments_f paaf
141: ,pay_all_payrolls_f ppf
142: -- ,hr_soft_coding_keyflex hsck
143: WHERE pas.payroll_action_id = ppa.payroll_action_id

Line 187: ,pay_pre_payments ppp

183: ,'NATIONAL_IDENTIFIER=P',min(pef.NATIONAL_IDENTIFIER)
184: FROM per_all_assignments_f paf
185: ,per_all_people_f pef
186: ,pay_all_payrolls_f ppf
187: ,pay_pre_payments ppp
188: ,pay_assignment_actions paa
189: ,pay_payroll_actions ppa
190: ,pay_personal_payment_methods_f ppmf
191: ,pay_external_accounts pea