DBA Data[Home] [Help]

APPS.JTF_DIAGNOSTIC dependencies on WF_ROLES

Line 3483: select distinct owner_tag from wf_roles where name in

3479:
3480: -- a cursor pointing to list of applications which are valid for
3481: -- user obtained using USER_NAME
3482: cursor valid_user_apps_cursor is
3483: select distinct owner_tag from wf_roles where name in
3484: ( select role_name from wf_user_roles where user_name=sys_context('FND','USER_NAME')
3485: and role_name not in ( 'FND_RESP|FND|APPLICATION_DIAGNOSTICS|STANDARD','UMX|ODF_APPLICATION_END_USER_ROLE',
3486: 'UMX|ODF_APPLICATION_SUPER_USER_ROLE','UMX|ODF_DIAGNOSTICS_SUPER_USER_ROLE')
3487: and sysdate >=start_date and start_date