DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on IBY_EXT_BANK_ACCOUNTS

Line 58: v_customer_alc IBY_EXT_BANK_ACCOUNTS.agency_location_code%TYPE;

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

Line 585: iby_ext_bank_accounts_v eb

581: FROM hz_cust_acct_sites_all hzcas,
582: hz_cust_site_uses_all hzcsu,
583: iby_external_payers_all payer,
584: iby_pmt_instr_uses_all iby_ins,
585: iby_ext_bank_accounts_v eb
586: WHERE hzcas.cust_account_id = transaction_rec.customer_id
587: AND hzcas.cust_acct_site_id = p_bill_to_address_id
588: AND hzcsu.cust_acct_site_id =hzcas.cust_acct_site_id
589: AND hzcsu.site_use_code = 'BILL_TO'