APPS.OE_ACCEPTANCE_UTIL dependencies on HZ_CUST_ACCT_SITES_ALL

Line 208: FROM hz_cust_acct_sites_all acct_site,

204: IF g_invoice_to_org_id_tbl(i) IS NOT NULL and g_invoice_to_org_id_tbl(i) <> -99 THEN
205: SELECT acct_site.cust_account_id, site.cust_acct_site_id
206: INTO g_invoice_to_customer_tbl(i),
207: g_invoice_to_site_tbl(i)
208: FROM hz_cust_acct_sites_all acct_site,
209: hz_cust_site_uses_all site
210: WHERE SITE.SITE_USE_CODE = 'BILL_TO'
211: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
212: AND SITE.SITE_USE_ID = g_invoice_to_org_id_tbl(i);

Line 223: FROM hz_cust_acct_sites_all acct_site,

219: IF g_ship_to_org_id_tbl(i) IS NOT NULL and g_ship_to_org_id_tbl(i) <> -99 THEN
220: SELECT acct_site.cust_account_id, site.cust_acct_site_id
221: INTO g_ship_to_customer_tbl(i),
222: g_ship_to_site_tbl(i)
223: FROM hz_cust_acct_sites_all acct_site,
224: hz_cust_site_uses_all site
225: WHERE SITE.SITE_USE_CODE = 'SHIP_TO'
226: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID
227: AND SITE.SITE_USE_ID = g_ship_to_org_id_tbl(i);