APPS.FTE_TRIP_RATING_GRP dependencies on WSH_TRIP_STOPS

Line 2192: wsh_trip_stops s

2188:
2189: CURSOR c_get_dlegs_from_trip(c_trip_id IN NUMBER) IS
2190: SELECT dl.delivery_leg_id
2191: FROM wsh_delivery_legs dl ,
2192: wsh_trip_stops s
2193: WHERE dl.pick_up_stop_id = s.stop_id
2194: and s.trip_id=c_trip_id;
2195:
2196: l_mode VARCHAR2(30);

Line 3575: wsh_trip_stops s

3571:
3572: CURSOR c_check_parent_exists(c_delivery_id IN Number,c_trip_id IN NUMBER) IS
3573: select dl.parent_delivery_leg_id
3574: FROM wsh_delivery_legs dl,
3575: wsh_trip_stops s
3576: WHERE dl.delivery_id=c_delivery_id
3577: AND dl.parent_delivery_leg_id is not null
3578: AND dl.pick_up_stop_id = s.stop_id
3579: AND s.trip_id=c_trip_id;