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 1168: from sys.dual

1164: -- check if new index name exists, if so, may ask to drop it.
1165: begin
1166: select null
1167: into v_dummy
1168: from sys.dual
1169: where exists (select 1
1170: from USER_OBJECTS
1171: where OBJECT_NAME = v_new_index
1172: );