APPS.PAY_CA_DIRECT_DEPOSIT_PKG dependencies on PAY_EXTERNAL_ACCOUNTS

Line 59: , pay_external_accounts pea

55: , 'CURRENCY_CODE=P', opm.currency_code
56: from
57: pay_org_payment_methods opm
58: , pay_personal_payment_methods ppm
59: , pay_external_accounts pea
60: , pay_pre_payments ppp
61: , per_people ppf
62: , per_assignments paf
63: , pay_assignment_actions paa

Line 139: , pay_external_accounts pea

135: , 'CURRENCY_CODE=P', opm.currency_code
136: from
137: pay_org_payment_methods opm
138: , pay_personal_payment_methods ppm
139: , pay_external_accounts pea
140: , pay_pre_payments ppp
141: , per_people ppf
142: , per_assignments paf
143: , pay_assignment_actions paa

Line 220: , pay_external_accounts pea

216: , 'CURRENCY_CODE=P', opm.currency_code
217: from
218: pay_org_payment_methods opm
219: , pay_personal_payment_methods ppm
220: , pay_external_accounts pea
221: , pay_pre_payments ppp
222: , per_people ppf
223: , per_assignments paf
224: , pay_assignment_actions paa

Line 259: pay_external_accounts pea

255: , 'RETURN_BANK_TRANSIT_NUMBER=P', pea.segment4
256: , 'BANK_NUMBER=P', pea.segment7
257: , 'BUSINESS_GROUP_ID=P', fnd_number.number_to_canonical(ppa.business_group_id)
258: from pay_org_payment_methods_f opm,
259: pay_external_accounts pea
260: , pay_payroll_actions ppa
261: where ppa.payroll_action_id =
262: pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
263: and ppa.org_payment_method_id = opm.org_payment_method_id

Line 303: , pay_external_accounts pea

299: , 'CURRENCY_CODE=P', opm.currency_code
300: from
301: pay_org_payment_methods opm
302: , pay_personal_payment_methods ppm
303: , pay_external_accounts pea
304: , pay_pre_payments ppp
305: , per_people ppf
306: , per_assignments paf
307: , pay_assignment_actions paa