DBA Data[Home] [Help]

APPS.FND_CONC_CONNECT dependencies on FND_RESPONSIBILITY

Line 103: -- from fnd_responsibility r,

99: -- select r.application_id,
100: -- r.responsibility_id
101: -- into resp_appl_id,
102: -- resp_id
103: -- from fnd_responsibility r,
104: -- fnd_user_resp_groups u
105: -- where u.user_id = l_user_id
106: -- and u.responsibility_id = r.responsibility_id
107: -- and u.responsibility_application_id = r.application_id

Line 123: from fnd_responsibility r,

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,
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