DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_USER_ROLES

Line 4191: from WF_USER_ROLES WUR

4187: rorig_system_id WF_LOCAL_ROLES.ORIG_SYSTEM_ID%TYPE;
4188:
4189: cursor role_users_curs is
4190: select WUR.USER_NAME
4191: from WF_USER_ROLES WUR
4192: where WUR.ROLE_ORIG_SYSTEM = rorig_system
4193: and WUR.ROLE_ORIG_SYSTEM_ID = rorig_system_id
4194: and WUR.ROLE_NAME = role;
4195:

Line 5152: from WF_USER_ROLES WUR

5148: select count(1)
5149: into ncount
5150: from WF_NOTIFICATIONS WN,
5151: (select WUR.ROLE_NAME
5152: from WF_USER_ROLES WUR
5153: where WUR.USER_NAME = WorkCount.username
5154: and WUR.USER_ORIG_SYSTEM = l_orig_system
5155: and WUR.USER_ORIG_SYSTEM_ID = l_orig_system_id
5156: ) wur