APPS.OE_HOLDS_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 38: by hz_cust_site_uses all for bug 1874065 */

34: oe_debug_pub.add( 'OEXPHLDB:IN PROCEDURE HOLD_SITE_CODE' , 1 ) ;
35: END IF;
36: -- Check to see if the Site code is Bill_to oe Ship_to
37: /* Backward compatible view ra_site_uses in following sql is replaced
38: by hz_cust_site_uses all for bug 1874065 */
39: BEGIN
40: SELECT site_use_code
41: INTO l_site_use_code
42: FROM hz_cust_site_uses -- Bug 2138398

Line 5233: FROM hz_cust_site_uses_all

5229:
5230: BEGIN
5231:
5232: SELECT org_id into l_org_id
5233: FROM hz_cust_site_uses_all
5234: WHERE site_use_id = p_hold_entity_id;
5235:
5236: IF l_org_id is null then
5237: IF l_debug_level > 0 THEN