DBA Data[Home] [Help]

APPS.FND_CONC_CONNECT dependencies on FND_USER

Line 104: -- fnd_user_resp_groups u

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
108: -- and r.responsibility_key='SYSTEM_ADMINISTRATION'

Line 121: fnd_user u, wf_local_user_roles wur

117:
118: select r.application_id, r.responsibility_id
119: into resp_appl_id, resp_id
120: from fnd_responsibility r,
121: fnd_user u, wf_local_user_roles wur
122: where r.responsibility_key = 'SYSTEM_ADMINISTRATION'
123: and r.responsibility_id = wur.role_orig_system_id
124: and r.application_id = (select application_id
125: from fnd_application