APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_DELIVERY_DETAILS

Line 3090: l_token := 'WSH_DELIVERY_DETAILS';

3086: wsh_debug_sv.push(l_module_name);
3087: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
3088: END IF;
3089: BEGIN
3090: l_token := 'WSH_DELIVERY_DETAILS';
3091: IF l_debug_on THEN
3092: wsh_debug_sv.LOG(l_module_name, 'Validating records in table : ', l_token);
3093: END IF;
3094: SELECT 'N'

Line 3096: FROM WSH_DELIVERY_DETAILS

3092: wsh_debug_sv.LOG(l_module_name, 'Validating records in table : ', l_token);
3093: END IF;
3094: SELECT 'N'
3095: INTO v_delete_permitted
3096: FROM WSH_DELIVERY_DETAILS
3097: WHERE SHIP_FROM_LOCATION_ID = P_LOCATION_ID
3098: AND ROWNUM =1;
3099:
3100: IF v_delete_permitted IS NOT NULL THEN