APPS.WSH_MAP_LOCATION_REGION_PKG dependencies on WSH_DELIVERY_DETAILS

Line 3106: l_token := 'WSH_DELIVERY_DETAILS';

3102: wsh_debug_sv.push(l_module_name);
3103: wsh_debug_sv.LOG(l_module_name, 'p_location_id', p_location_id);
3104: END IF;
3105: BEGIN
3106: l_token := 'WSH_DELIVERY_DETAILS';
3107: IF l_debug_on THEN
3108: wsh_debug_sv.LOG(l_module_name, 'Validating records in table : ', l_token);
3109: END IF;
3110: SELECT 'N'

Line 3112: FROM WSH_DELIVERY_DETAILS

3108: wsh_debug_sv.LOG(l_module_name, 'Validating records in table : ', l_token);
3109: END IF;
3110: SELECT 'N'
3111: INTO v_delete_permitted
3112: FROM WSH_DELIVERY_DETAILS
3113: WHERE SHIP_FROM_LOCATION_ID = P_LOCATION_ID
3114: AND ROWNUM =1;
3115:
3116: IF v_delete_permitted IS NOT NULL THEN