DBA Data[Home] [Help]

APPS.FTE_TL_CACHE dependencies on WSH_NEW_DELIVERIES

Line 7609: FROM wsh_new_deliveries d

7605: 0,
7606: 0,
7607: null,
7608: null
7609: FROM wsh_new_deliveries d
7610: WHERE d.delivery_id =c_delivery_id;
7611:
7612:
7613: CURSOR get_dates_loc_from_dlv(c_delivery_id IN NUMBER) IS

Line 7618: FROM wsh_new_deliveries d

7614: SELECT d.initial_pickup_date,
7615: d.ultimate_dropoff_date,
7616: d.initial_pickup_location_id,
7617: d.ultimate_dropoff_location_id
7618: FROM wsh_new_deliveries d
7619: WHERE d.delivery_id=c_delivery_id;
7620:
7621: CURSOR get_dleg_info(c_dleg_id IN NUMBER) RETURN
7622: TL_delivery_leg_rec_type IS

Line 10282: FROM wsh_new_deliveries d

10278: SELECT d.initial_pickup_date,
10279: d.ultimate_dropoff_date,
10280: d.initial_pickup_location_id,
10281: d.ultimate_dropoff_location_id
10282: FROM wsh_new_deliveries d
10283: WHERE d.delivery_id=c_delivery_id;
10284:
10285:
10286: