APPS.WSH_DELIVERY_LEGS_ACTIONS dependencies on DUAL

Line 547: FROM dual

543: ID,
544: FLAG,
545: COLUMN1)
546: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(p_sc_pickup_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
547: FROM dual
548: WHERE NOT EXISTS (
549: select 'x'
550: from wsh_tmp wt1
551: where wt1.id = l_pickup_location_id_tbl(i)

Line 556: FROM dual

552: and wt1.flag='P'
553: and wt1.column1 = to_char(nvl(p_sc_pickup_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS'))
554: UNION
555: SELECT l_dropoff_location_id_tbl(i), 'D', to_char(nvl(p_sc_dropoff_date,l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
556: FROM dual
557: WHERE NOT EXISTS (
558: select 'x'
559: from wsh_tmp wt1
560: where wt1.id = l_dropoff_location_id_tbl(i)

Line 570: FROM dual

566: ID,
567: FLAG,
568: COLUMN1)
569: SELECT l_pickup_location_id_tbl(i), 'P', to_char(nvl(l_pickup_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
570: FROM dual
571: WHERE NOT EXISTS (
572: select 'x'
573: from wsh_tmp wt1
574: where wt1.id = l_pickup_location_id_tbl(i)

Line 579: FROM dual

575: and wt1.flag='P'
576: and wt1.column1 = to_char(nvl(l_pickup_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS'))
577: UNION
578: SELECT l_dropoff_location_id_tbl(i), 'D', to_char(nvl(l_dropoff_date_tbl(i),l_sysdate), 'DD-MM-RRRR HH24:MI:SS')
579: FROM dual
580: WHERE NOT EXISTS (
581: select 'x'
582: from wsh_tmp wt1
583: where wt1.id = l_dropoff_location_id_tbl(i)