APPS.WSH_TRIP_STOPS_PVT dependencies on WSH_DELIVERY_LEGS

Line 407: FROM wsh_delivery_legs

403: WHERE stop_id = v_stop_id;
404:
405: CURSOR get_del_leg_id (cp_stop_id NUMBER) IS
406: SELECT delivery_leg_id
407: FROM wsh_delivery_legs
408: WHERE pick_up_stop_id = cp_stop_id OR
409: drop_off_stop_id = cp_stop_id;
410:
411: --OTM R12, glog proj

Line 570: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg (

566: IF l_debug_on THEN
567: WSH_DEBUG_SV.log(l_module_name,'Calling Delete_Delivery_Leg delivery_leg_id',rec.delivery_leg_id);
568: END IF;
569:
570: WSH_DELIVERY_LEGS_PVT.Delete_Delivery_Leg (
571: p_delivery_leg_id => rec.delivery_leg_id,
572: x_return_status => l_return_status);
573:
574: IF l_debug_on THEN

Line 1668: FROM wsh_delivery_legs

1664: WHERE trip_id = p_entity_id;
1665:
1666: CURSOR has_pick_up_deliveries(x_stop_id NUMBER) IS
1667: SELECT delivery_id
1668: FROM wsh_delivery_legs
1669: WHERE pick_up_stop_id = x_stop_id
1670: AND rownum = 1;
1671:
1672: CURSOR has_drop_off_deliveries(x_stop_id NUMBER) IS

Line 1674: FROM wsh_delivery_legs

1670: AND rownum = 1;
1671:
1672: CURSOR has_drop_off_deliveries(x_stop_id NUMBER) IS
1673: SELECT delivery_id
1674: FROM wsh_delivery_legs
1675: WHERE drop_off_stop_id = x_stop_id
1676: AND rownum = 1;
1677:
1678: