DBA Data[Home] [Help]

APPS.WF_PLUG dependencies on WF_USER_ROLES

Line 529: from WF_USER_ROLES WUR

525: and WL.LOOKUP_TYPE = 'WF_NOTIFICATION_STATUS'
526: and WN.STATUS = WL.LOOKUP_CODE
527: and WN.RECIPIENT_ROLE in
528: (select WUR.ROLE_NAME
529: from WF_USER_ROLES WUR
530: where WUR.USER_ORIG_SYSTEM = Worklist.uorig_system
531: and WUR.USER_ORIG_SYSTEM_ID = Worklist.uorig_system_id
532: and WUR.USER_NAME = Worklist.username)
533: and ((Worklist.lfromuser = '*' ) or