APPS.FTE_WORKFLOW_UTIL dependencies on WSH_DELIVERY_LEGS

Line 19: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL

15: --========================================================================
16: CURSOR Get_Trip_Deliveries(c_trip_id NUMBER)
17: IS
18: SELECT WDL.DELIVERY_ID
19: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
20: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
21: AND WTS.TRIP_ID = c_trip_id;
22:
23: --========================================================================

Line 33: FROM WSH_DELIVERY_LEGS WDL

29: --========================================================================
30: CURSOR Get_Dleg_Delivery(c_dleg_id NUMBER)
31: IS
32: SELECT WDL.DELIVERY_ID
33: FROM WSH_DELIVERY_LEGS WDL
34: WHERE WDL.DELIVERY_LEG_ID = c_dleg_id;
35:
36: --========================================================================
37: -- CURSOR : Get_Dleg_Trip

Line 46: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL

42: --========================================================================
43: CURSOR Get_Dleg_Trip(c_dleg_id NUMBER)
44: IS
45: SELECT WTS.TRIP_ID
46: FROM WSH_TRIP_STOPS WTS, WSH_DELIVERY_LEGS WDL
47: WHERE WTS.STOP_ID = WDL.PICK_UP_STOP_ID
48: AND WDL.DELIVERY_LEG_ID = c_dleg_id;
49:
50: --========================================================================