APPS.FV_IPAC dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 518: FROM ar_receipt_method_accounts_all arma,

514: BEGIN
515:
516: SELECT aba.agency_location_code
517: INTO v_sender_alc
518: FROM ar_receipt_method_accounts_all arma,
519: ap_bank_accounts aba
520: WHERE aba.bank_account_id = arma.bank_account_id
521: AND aba.currency_code = nvl(parm_currency,v_invoice_currency)
522: AND arma.primary_flag = 'Y'

Line 2165: FROM ar_receipt_method_accounts arma,

2161:
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

Line 2230: FROM ar_receipt_method_accounts_all arma,

2226: || to_char(x_cash_receipt_id));
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'