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
2676: ** for this user.
2677: */
2678: SELECT USERENV('LANG')
2679: INTO l_lang
2680: FROM DUAL;
2681:
2682: EXCEPTION
2683: WHEN OTHERS THEN
2684: l_lang := 'US';