DBA Data[Home] [Help]

APPS.FTE_WORKFLOW_UTIL dependencies on WSH_TRIP_STOPS

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 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: --========================================================================