DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on PAY_EXTERNAL_ACCOUNTS

Line 1699: , pay_external_accounts ea

1695: --
1696: CURSOR cbank_info(l_org_method_id number) is
1697: SELECT ea.segment2 || ea.segment3 || replace(ea.segment5,'-','')
1698: FROM pay_org_payment_methods_f opm
1699: , pay_external_accounts ea
1700: WHERE opm.org_payment_method_id = l_org_method_id
1701: AND opm.external_account_id = ea.external_account_id
1702: AND g_effective_date between opm.effective_start_date
1703: and opm.effective_end_date;

Line 2484: , pay_external_accounts ea

2480: --
2481: CURSOR cbank_info(l_org_method_id number) is
2482: SELECT ea.segment2 || ea.segment3 || replace(ea.segment5,'-','')
2483: FROM pay_org_payment_methods_f opm
2484: , pay_external_accounts ea
2485: WHERE opm.org_payment_method_id = l_org_method_id
2486: AND opm.external_account_id = ea.external_account_id
2487: AND l_period_end_date between opm.effective_start_date
2488: and opm.effective_end_date;