APPS.WSH_DELIVERY_SPLITTER_PKG dependencies on WSH_DELIVERY_LEGS

Line 281: FROM WSH_DELIVERY_LEGS

277:
278: -- check if delivery is assigned to a trip
279: CURSOR c_is_delivery_assigned(p_delivery_id IN NUMBER) IS
280: SELECT 1
281: FROM WSH_DELIVERY_LEGS
282: WHERE delivery_id = p_delivery_id
283: AND rownum = 1;
284:
285: l_current_weight WSH_NEW_DELIVERIES.GROSS_WEIGHT%TYPE; -- variable used to track delivery weight