DBA Data[Home] [Help]

APPS.FND_WF_ENGINE dependencies on WF_USER_ROLES

Line 1088: from WF_USER_ROLES WUR

1084: and NATTR.NOTIFICATION_ID = WN.NOTIFICATION_ID
1085: and NATTR.NAME = l_name
1086: and WN.RECIPIENT_ROLE in
1087: (select WUR.ROLE_NAME
1088: from WF_USER_ROLES WUR
1089: where WUR.USER_NAME = l_username);
1090: else
1091: select count(1)
1092: into disable_or_launch

Line 1104: from WF_USER_ROLES WUR

1100: and NATTR.NOTIFICATION_ID = WN.NOTIFICATION_ID
1101: and NATTR.NAME = l_name
1102: and WN.RECIPIENT_ROLE in
1103: (select WUR.ROLE_NAME
1104: from WF_USER_ROLES WUR
1105: where WUR.USER_ORIG_SYSTEM = substr(l_username, 1, colon-1)
1106: and WUR.USER_ORIG_SYSTEM_ID = substr(l_username, colon+1)
1107: and WUR.USER_NAME = l_username
1108: and WUR.USER_ORIG_SYSTEM not in