DBA Data[Home] [Help]

APPS.PAY_NL_PAYFILE_SEPA dependencies on PAY_EXTERNAL_ACCOUNTS

Line 139: PAY_EXTERNAL_ACCOUNTS pea,

135: hr_organization_information hoi,
136: pay_org_payment_methods_f popmf,
137: PAY_ORG_PAY_METHOD_USAGES_F popmu,
138: PAY_ALL_PAYROLLS_F papf,
139: PAY_EXTERNAL_ACCOUNTS pea,
140: PAY_PAYROLL_ACTIONS ppa
141: where
142: ppa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID') and
143: hou.business_group_id = ppa.business_group_id and

Line 231: ,pay_external_accounts pea

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
232: WHERE paa.payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
233: AND paa.pre_payment_id = ppp.pre_payment_id
234: AND paa.payroll_action_id = ppa.payroll_action_id
235: AND PPP.personal_payment_method_id = ppmf.personal_payment_method_id