APPS.WMS_TRIPSTOPS_STAGELANES_PUB dependencies on DUAL
Line 342: FROM DUAL WHERE EXISTS (SELECT staging_lane_id
338: -- Bug 4915199, changing 'trunc(end_time)>=trunc(sysdate)' to 'end_time>=sysdate'
339: -- to take time of the day into consideration.
340:
341: SELECT 1 into l_dummy 342: FROM DUAL WHERE EXISTS (SELECT staging_lane_id 343: FROM wms_dock_appointments_b
344: WHERE staging_lane_id = p_stg_lane_id
345: and end_time>=sysdate);
346: