APPS.WSH_VENDOR_PARTY_MERGE_PKG dependencies on DUAL

Line 3514: from dual

3510: FOR UPDATE NOWAIT;
3511:
3512: CURSOR c_check_vendor_wdd (c_vendor_id NUMBER) IS
3513: select 'x'
3514: from dual
3515: where exists (
3516: select 1
3517: from wsh_delivery_details
3518: where consignee_flag = 'V'

Line 3523: from dual

3519: and customer_id = c_vendor_id);
3520:
3521: CURSOR c_check_vendor_wnd (c_vendor_id NUMBER) IS
3522: select 'x'
3523: from dual
3524: where exists (
3525: select 1
3526: from wsh_new_deliveries
3527: where consignee_flag = 'V'

Line 3893: FROM dual

3889:
3890: FORALL I IN l_delivery_id.first..l_delivery_id.last
3891: INSERT INTO wsh_tmp ( column1, column2, column3 )
3892: SELECT l_delivery_id(i), l_stop_id(i), l_delivery_detail_id(i)
3893: FROM dual
3894: WHERE l_delivery_id(i) IS NOT NULL
3895: AND NOT EXISTS
3896: ( SELECT 'x'
3897: FROM wsh_tmp