579: SELECT eb.agency_location_code
580: INTO v_customer_alc
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