APPS.WSH_TRIP_STOPS_ACTIONS dependencies on DUAL

Line 314: SELECT 1 from dual

310: dl.status_code IN ('OP','PA', 'SA') -- sperera 940/945
311: AND nvl(dl.shipment_direction,'O') IN ('O','IO');
312:
313: CURSOR stop_pickups (l_stop_id NUMBER) IS
314: SELECT 1 from dual
315: WHERE exists ( select 1
316: FROM wsh_delivery_legs dg,
317: wsh_new_deliveries dl
318: WHERE dg.delivery_id = dl.delivery_id