APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 148: FROM HZ_CUST_SITE_USES_ALL SITE,

144: END IF;
145:
146: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
147: Into l_dummy
148: FROM HZ_CUST_SITE_USES_ALL SITE,
149: HZ_CUST_ACCT_SITES ACCT_SITE
150: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
151: AND SITE.SITE_USE_CODE = l_site_use_code
152: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 227: FROM HZ_CUST_SITE_USES_ALL SITE,

223: END IF;
224:
225: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
226: Into l_dummy
227: FROM HZ_CUST_SITE_USES_ALL SITE,
228: HZ_CUST_ACCT_SITES ACCT_SITE
229: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
230: AND SITE.SITE_USE_CODE = l_site_use_code
231: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 315: FROM HZ_CUST_SITE_USES_ALL SITE,

311: END IF;
312:
313: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
314: Into l_dummy
315: FROM HZ_CUST_SITE_USES_ALL SITE,
316: HZ_CUST_ACCT_SITES ACCT_SITE
317: WHERE SITE.SITE_USE_ID = p_invoice_to_org_id
318: AND SITE.SITE_USE_CODE = l_site_use_code
319: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID