DBA Data[Home] [Help]

APPS.WF_SETUP dependencies on DUAL

Line 131: from sys.dual

127:
128: -- find out if such dblr.name exists
129: begin
130: select 'EXIST' into dTab(i).col02
131: from sys.dual
132: where upper(dblr.name) in (
133: select DB_LINK from USER_DB_LINKS
134: union all
135: select DB_LINK from ALL_DB_LINKS

Line 463: from sys.dual

459: if (dTab(i).col03 is null) then
460: begin
461: select null
462: into dTab(i).col03
463: from sys.dual
464: where exists (
465: select NULL
466: from DBA_QUEUE_SCHEDULES QS
467: where QS.DESTINATION = nvl(ppgr.tosystem, 'AQ$_LOCAL')