APPS.OE_BLANKET_UTIL dependencies on HZ_CUST_SITE_USES_ALL

Line 59: FROM HZ_CUST_SITE_USES_ALL SITE,

55: END IF;
56:
57: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
58: Into l_dummy
59: FROM HZ_CUST_SITE_USES_ALL SITE,
60: HZ_CUST_ACCT_SITES ACCT_SITE
61: WHERE SITE.SITE_USE_ID = p_ship_to_org_id
62: AND SITE.SITE_USE_CODE = l_site_use_code
63: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 138: FROM HZ_CUST_SITE_USES_ALL SITE,

134: END IF;
135:
136: SELECT /* MOAC_SQL_CHANGE */ 'VALID'
137: Into l_dummy
138: FROM HZ_CUST_SITE_USES_ALL SITE,
139: HZ_CUST_ACCT_SITES ACCT_SITE
140: WHERE SITE.SITE_USE_ID = p_deliver_to_org_id
141: AND SITE.SITE_USE_CODE = l_site_use_code
142: AND SITE.CUST_ACCT_SITE_ID = ACCT_SITE.CUST_ACCT_SITE_ID

Line 226: FROM HZ_CUST_SITE_USES_ALL SITE,

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