APPS.FTE_MLS_WRAPPER dependencies on WSH_DELIVERY_LEGS

Line 598: FROM wsh_delivery_legs wdl,

594: --{
595: CURSOR delivery_leg_cur
596: IS
597: SELECT delivery_leg_id, sequence_number
598: FROM wsh_delivery_legs wdl,
599: wsh_trip_stops wts
600: WHERE wts.trip_id = p_asg_trip_id
601: AND wts.stop_id = wdl.pick_up_stop_id
602: AND wdl.pick_up_stop_id = p_asg_pickup_stop_id

Line 1815: FROM WSH_DELIVERY_LEGS LEGS,

1811:
1812:
1813: CURSOR c_numberOfDel(p_TripID NUMBER) IS
1814: SELECT COUNT(LEGS.DELIVERY_ID)
1815: FROM WSH_DELIVERY_LEGS LEGS,
1816: WSH_TRIP_STOPS ST
1817: WHERE
1818: ST.STOP_ID = LEGS.PICK_UP_STOP_ID
1819: AND ST.TRIP_ID = p_TripID;