DBA Data[Home] [Help]

APPS.FND_CONC_CONNECT dependencies on WF_USER_ROLES

Line 119: -- Replaced WF_LOCAL_USER_ROLES in the query with WF_LOCAL_ROLES and WF_USER_ROLES

115: -- bug5007493
116: -- performance update
117:
118: -- bug 5693125
119: -- Replaced WF_LOCAL_USER_ROLES in the query with WF_LOCAL_ROLES and WF_USER_ROLES
120:
121: select r.application_id, r.responsibility_id
122: into resp_appl_id, resp_id
123: from fnd_responsibility r,

Line 124: fnd_user u, wf_user_roles wur,wf_local_roles wr

120:
121: select r.application_id, r.responsibility_id
122: into resp_appl_id, resp_id
123: from fnd_responsibility r,
124: fnd_user u, wf_user_roles wur,wf_local_roles wr
125: where r.responsibility_key = 'SYSTEM_ADMINISTRATION'
126: and r.responsibility_id = wur.role_orig_system_id
127: and r.application_id = (select application_id
128: from fnd_application