DBA Data[Home] [Help]

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: