DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on CE_BANK_ACCOUNTS

Line 2118: Ce_bank_accounts cba,

2114: BEGIN --Bug 5641377, 7113869
2115: SELECT cba.agency_location_code
2116: INTO v_sender_alc
2117: FROM ar_receipt_method_accounts arma,
2118: Ce_bank_accounts cba,
2119: CE_BANK_ACCT_USES_ALL cbal
2120: WHERE cbal.bank_account_id =cba.bank_account_id
2121: AND cbal.bank_acct_use_id = arma.remit_bank_acct_use_id
2122: AND cba.currency_code = (p_currency_code)

Line 2167: Ce_bank_accounts cba

2163:
2164: /* SELECT cba.agency_location_code
2165: INTO v_sender_alc
2166: FROM ar_receipt_method_accounts_all arma,
2167: Ce_bank_accounts cba
2168: WHERE cba.bank_account_id = arma.remit_bank_acct_use_id
2169: AND cba.currency_code = (p_currency_code)
2170: AND arma.primary_flag = 'Y'
2171: AND arma.receipt_method_id = p_receipt_method_id; */