DBA Data[Home] [Help]

APPS.WSH_PARTY_MERGE dependencies on DUAL

Line 1748: FROM Dual;

1744: FOR UPDATE OF Wda.Delivery_Detail_Id;
1745:
1746: CURSOR Get_Grouping_Id is
1747: SELECT Wsh_Delivery_Group_S.NEXTVAL
1748: FROM Dual;
1749:
1750: -- Bug 5606960# Cursor added for G-Log Changes
1751: CURSOR Get_Tmp_Deliveries
1752: IS

Line 2100: FROM dual

2096: -- Dulplicate entries are avoided using NOT EXISTS condition
2097: FORALL i IN l_delivery_id_tab.FIRST..l_delivery_id_tab.LAST
2098: INSERT INTO wsh_tmp(column1, column2, column3)
2099: SELECT l_delivery_id_tab(i), l_stop_id_tab(i), l_del_detail_id_tab(i)
2100: FROM dual
2101: WHERE l_delivery_id_tab(i) is not null
2102: AND NOT EXISTS
2103: ( SELECT 'x'
2104: FROM Wsh_Tmp