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 5780: FROM hz_cust_site_uses_all

5776:
5777: BEGIN
5778:
5779: SELECT org_id into l_org_id
5780: FROM hz_cust_site_uses_all
5781: WHERE site_use_id = p_hold_entity_id;
5782:
5783: IF l_org_id is null then
5784: IF l_debug_level > 0 THEN