DBA Data[Home] [Help]

APPS.PAY_FR_DUCS dependencies on PAY_ORG_PAYMENT_METHODS_F

Line 1698: FROM pay_org_payment_methods_f opm

1694: -- Cursor to retrieve Bank Info
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

Line 2483: FROM pay_org_payment_methods_f opm

2479: -- Cursor to retrieve Bank Info
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