APPS.WFA_HTML dependencies on DUAL

Line 446: from sys.dual

442: -- rewritten the sql from an or join to union all.
443: -- reduced the query time from >25 sec to <0.5 sec.
444: select 1
445: into dummy
446: from sys.dual
447: where exists (
448: select null
449: from WF_USER_ROLES
450: where USER_ORIG_SYSTEM = uos

Line 1130: FROM DUAL;

1126: ** for this user.
1127: */
1128: SELECT USERENV('LANG')
1129: INTO l_lang
1130: FROM DUAL;
1131:
1132: EXCEPTION
1133: WHEN OTHERS THEN
1134: l_lang := 'US';