APPS.EGO_REPORT_WF_UTIL dependencies on WF_LOCAL_ROLES

Line 268: from WF_LOCAL_ROLES

264: IS
265: SELECT 'Role Exists'
266: FROM DUAL
267: WHERE EXISTS ( SELECT null
268: from WF_LOCAL_ROLES
269: WHERE NAME = p_role_name
270: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'
271: AND ORIG_SYSTEM_ID = 0
272: ) ;

Line 270: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'

266: FROM DUAL
267: WHERE EXISTS ( SELECT null
268: from WF_LOCAL_ROLES
269: WHERE NAME = p_role_name
270: AND ORIG_SYSTEM = 'WF_LOCAL_ROLES'
271: AND ORIG_SYSTEM_ID = 0
272: ) ;
273:
274: BEGIN

Line 326: -- DELETE FROM wf_local_roles

322: -- Instead of this, Set Adhoc Role Expiration
323: -- using WF API. Then once user run WF Purge progam
324: -- deleting these role and user roles is taken care of.
325:
326: -- DELETE FROM wf_local_roles
327: -- WHERE name = p_role_name ;
328:
329: -- DELETE FROM wf_local_user_roles
330: -- WHERE role_name = p_role_name ;