APPS.FV_IPAC dependencies on AR_RECEIPT_METHOD_ACCOUNTS

Line 510: FROM ar_receipt_method_accounts_all arma,

506: BEGIN
507:
508: SELECT aba.agency_location_code
509: INTO v_sender_alc
510: FROM ar_receipt_method_accounts_all arma,
511: ap_bank_accounts aba
512: WHERE aba.bank_account_id = arma.bank_account_id
513: AND aba.currency_code = nvl(parm_currency,v_invoice_currency)
514: AND arma.primary_flag = 'Y'

Line 2117: FROM ar_receipt_method_accounts arma,

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

Line 2166: FROM ar_receipt_method_accounts_all arma,

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