DBA Data[Home] [Help]

APPS.WFA_HTML dependencies on WF_USER_ROLES

Line 449: from WF_USER_ROLES

445: into dummy
446: from sys.dual
447: where exists (
448: select null
449: from WF_USER_ROLES
450: where USER_ORIG_SYSTEM = uos
451: and USER_ORIG_SYSTEM_ID = uosid
452: and USER_NAME = username
453: and ROLE_ORIG_SYSTEM = ros

Line 458: from WF_USER_ROLES

454: and ROLE_ORIG_SYSTEM_ID = rosid
455: and ROLE_NAME = recipient
456: union all
457: select null
458: from WF_USER_ROLES
459: where USER_ORIG_SYSTEM = uos
460: and USER_ORIG_SYSTEM_ID = uosid
461: and USER_NAME = username
462: and ROLE_ORIG_SYSTEM = oos