DBA Data[Home] [Help]

APPS.WFA_HTML_JSP dependencies on WF_USER_ROLES

Line 60: from WF_USER_ROLES WUR

56: from WF_NOTIFICATIONS
57: where more_info_role is null
58: and RECIPIENT_ROLE in
59: (select WUR.ROLE_NAME
60: from WF_USER_ROLES WUR
61: where WUR.USER_ORIG_SYSTEM = getSSPNid.uorig_system
62: and WUR.USER_ORIG_SYSTEM_ID = getSSPNid.uorig_system_id
63: and WUR.USER_NAME = username)
64: ) v

Line 133: from WF_USER_ROLES WUR

129: from WF_NOTIFICATIONS
130: where more_info_role is null
131: and RECIPIENT_ROLE in
132: (select WUR.ROLE_NAME
133: from WF_USER_ROLES WUR
134: where WUR.USER_ORIG_SYSTEM = getSSPOpenNid.uorig_system
135: and WUR.USER_ORIG_SYSTEM_ID = getSSPOpenNid.uorig_system_id
136: and WUR.USER_NAME = username)
137: and status = 'OPEN'