DBA Data[Home] [Help]

APPS.FV_IPAC dependencies on HZ_CUST_SITE_USES_ALL

Line 582: hz_cust_site_uses_all hzcsu,

578: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name, 'Customer ID = ' || transaction_rec.customer_id || ' p_bill_to_address_id = ' || p_bill_to_address_id);
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