DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on CE_BANK_ACCOUNTS

Line 2166: Ce_bank_accounts cba,

2162: BEGIN --Bug 5641377, 7113869
2163: SELECT cba.agency_location_code
2164: INTO v_sender_alc
2165: FROM ar_receipt_method_accounts arma,
2166: Ce_bank_accounts cba,
2167: CE_BANK_ACCT_USES_ALL cbal
2168: WHERE cbal.bank_account_id =cba.bank_account_id
2169: AND cbal.bank_acct_use_id = arma.remit_bank_acct_use_id
2170: AND cba.currency_code = (p_currency_code)

Line 2231: Ce_bank_accounts cba

2227:
2228: /* SELECT cba.agency_location_code
2229: INTO v_sender_alc
2230: FROM ar_receipt_method_accounts_all arma,
2231: Ce_bank_accounts cba
2232: WHERE cba.bank_account_id = arma.remit_bank_acct_use_id
2233: AND cba.currency_code = (p_currency_code)
2234: AND arma.primary_flag = 'Y'
2235: AND arma.receipt_method_id = p_receipt_method_id; */