DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on IBY_EXT_BANK_ACCOUNTS

Line 57: v_customer_alc IBY_EXT_BANK_ACCOUNTS.agency_location_code%TYPE;

53: v_ccid NUMBER;
54: v_org_id fv_operating_units.org_id%TYPE;
55: v_sender_alc fv_operating_units.alc_code%TYPE;
56: --v_customer_alc ap_bank_accounts.agency_location_code%TYPE; changed
57: v_customer_alc IBY_EXT_BANK_ACCOUNTS.agency_location_code%TYPE;
58: v_receipt_method_id NUMBER;
59: v_original_amount NUMBER;
60: v_paid_amount NUMBER;
61: trx_exception_flag VARCHAR2(1) ;

Line 598: iby_ext_bank_accounts_v eb

594: FROM hz_cust_acct_sites_all hzcas,
595: hz_cust_site_uses_all hzcsu,
596: iby_external_payers_all payer,
597: iby_pmt_instr_uses_all iby_ins,
598: iby_ext_bank_accounts_v eb
599: WHERE hzcas.cust_account_id = transaction_rec.customer_id
600: AND hzcas.cust_acct_site_id = p_bill_to_address_id
601: AND hzcsu.cust_acct_site_id =hzcas.cust_acct_site_id
602: AND hzcsu.site_use_code = 'BILL_TO'