APPS.OE_PREPAYMENT_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 377: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site

373: --changes for bug#8854662 start
374: BEGIN
375: SELECT acct_site.cust_account_id
376: INTO l_hdr_inv_to_cust_id
377: FROM hz_cust_acct_sites_all acct_site, hz_cust_site_uses_all site
378: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
379: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
380: AND SITE.SITE_USE_ID = p_header_rec.invoice_to_org_id;
381: EXCEPTION