DBA Data[Home] [Help]

APPS.OE_NOTIFY_USER_WF dependencies on WF_ROLES

Line 229: FROM wf_roles

225:
226: IF l_eid IS NULL THEN
227: SELECT name
228: INTO l_role_name
229: FROM wf_roles
230: WHERE orig_system = 'FND_USR'
231: AND orig_system_id = G_USER_TAB(idx).user_id;
232: ELSE
233: SELECT name

Line 235: FROM wf_roles

231: AND orig_system_id = G_USER_TAB(idx).user_id;
232: ELSE
233: SELECT name
234: INTO l_role_name
235: FROM wf_roles
236: WHERE orig_system = 'PER'
237: AND parent_orig_system = 'HZ_PARTY'
238: AND orig_system_id = l_eid;
239: END IF;