DBA Data[Home] [Help]

APPS.WF_INSTALL dependencies on DUAL

Line 106: INTO v_dummy from sys.dual

102:
103: -- check if new table name exists, if so, may ask to drop it.
104: begin
105: SELECT null
106: INTO v_dummy from sys.dual
107: WHERE exists (
108: SELECT 1
109: FROM USER_OBJECTS
110: WHERE OBJECT_NAME = v_new_table

Line 336: FROM sys.dual

332: -- check if new table name exists, if so, may ask to drop it.
333: begin
334: SELECT null
335: INTO v_dummy
336: FROM sys.dual
337: WHERE exists (SELECT 1
338: FROM USER_OBJECTS
339: WHERE OBJECT_NAME = v_new_table
340: );

Line 571: FROM sys.dual

567: -- check if new index name exists, if so, may ask to drop it.
568: begin
569: SELECT null
570: INTO v_dummy
571: FROM sys.dual
572: WHERE exists (
573: SELECT 1
574: FROM USER_OBJECTS
575: WHERE OBJECT_NAME = v_new_index

Line 1157: from sys.dual

1153: -- check if new index name exists, if so, may ask to drop it.
1154: begin
1155: select null
1156: into v_dummy
1157: from sys.dual
1158: where exists (select 1
1159: from USER_OBJECTS
1160: where OBJECT_NAME = v_new_index
1161: );