445: SELECT cust.cust_account_id
446: INTO l_customer_id
447: FROM hz_cust_site_uses_all site,
448: hz_cust_acct_sites_all cas,
449: hz_cust_accounts cust,
450: hz_parties party
451: WHERE site.site_use_code = 'BILL_TO'
452: AND site.site_use_id = l_invoice_to_org_id
453: AND site.cust_acct_site_id = cas.cust_acct_site_id