DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC dependencies on WF_USER_ROLES

Line 3204: ( select role_name from wf_user_roles where user_name=sys_context('FND','USER_NAME')

3200: -- a cursor pointing to list of applications which are valid for
3201: -- user obtained using USER_NAME
3202: cursor valid_user_apps_cursor is
3203: select distinct owner_tag from wf_roles where name in
3204: ( select role_name from wf_user_roles where user_name=sys_context('FND','USER_NAME')
3205: and role_name not in ( 'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD','UMX|ODF_APPLICATION_END_USER_ROLE',
3206: 'UMX|ODF_APPLICATION_SUPER_USER_ROLE','UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE')
3207: and sysdate >=start_date and start_date 3208: and nvl2(expiration_date,expiration_date,sysdate+1) >= sysdate