APPS.FTE_TRIP_RATING_GRP dependencies on WSH_DELIVERY_LEGS

Line 2191: FROM wsh_delivery_legs dl ,

2187: AND s.schedules_id = c_schedule_id;
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:

Line 3574: FROM wsh_delivery_legs dl,

3570: WHERE delivery_id=c_delivery_id;
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