3831:
3832: CURSOR c_trip_info(p_delivery_id IN NUMBER) IS
3833: SELECT s1.trip_id,
3834: NVL(d.ignore_for_planning, 'N') --OTM R12, delivery ignore same as trip's
3835: FROM wsh_delivery_legs l, wsh_trip_stops s1, wsh_new_deliveries d
3836: WHERE l.delivery_id = p_delivery_id
3837: AND d.delivery_id = l.delivery_id
3838: AND s1.stop_id = l.pick_up_stop_id
3839: AND s1.stop_location_id = d.initial_pickup_location_id;
3839: AND s1.stop_location_id = d.initial_pickup_location_id;
3840:
3841: CURSOR c_empty_stops(p_trip_id NUMBER) IS
3842: SELECT wts.stop_id
3843: FROM wsh_trip_stops wts
3844: WHERE wts.trip_id = p_trip_id
3845: AND NOT EXISTS (
3846: SELECT wdl.delivery_leg_id
3847: FROM wsh_delivery_legs wdl