APPS.MSC_PHUB_UTIL dependencies on FND_USER

Line 198: from fnd_user u, fnd_user_resp_groups g

194: l_user_name varchar2(80);
195: begin
196: select distinct u.user_name
197: into l_user_name
198: from fnd_user u, fnd_user_resp_groups g
199: where u.user_id=g.user_id
200: and g.responsibility_application_id=724
201: and sysdate between u.start_date and nvl(u.end_date, sysdate)
202: and u.user_id=p_user_id;

Line 217: from fnd_user_resp_groups furg,

213: SECURITY_CONTEXT_INVALID exception;
214:
215: cursor c_user_info (ll_user varchar2) is
216: select furg.user_id, furg.responsibility_id, responsibility_application_id
217: from fnd_user_resp_groups furg,
218: fnd_user fu,
219: fnd_responsibility fr
220: where furg.user_id = fu.user_id
221: and furg.responsibility_id = fr.responsibility_id

Line 218: fnd_user fu,

214:
215: cursor c_user_info (ll_user varchar2) is
216: select furg.user_id, furg.responsibility_id, responsibility_application_id
217: from fnd_user_resp_groups furg,
218: fnd_user fu,
219: fnd_responsibility fr
220: where furg.user_id = fu.user_id
221: and furg.responsibility_id = fr.responsibility_id
222: and furg.responsibility_application_id = fr.application_id

Line 229: from fnd_user_resp_groups furg,

225: and fr.application_id = 724;
226:
227: cursor c_admin_info (ll_user varchar2) is
228: select furg.user_id, furg.responsibility_id, responsibility_application_id
229: from fnd_user_resp_groups furg,
230: fnd_user fu,
231: fnd_responsibility fr
232: where furg.user_id = fu.user_id
233: and furg.responsibility_id = fr.responsibility_id

Line 230: fnd_user fu,

226:
227: cursor c_admin_info (ll_user varchar2) is
228: select furg.user_id, furg.responsibility_id, responsibility_application_id
229: from fnd_user_resp_groups furg,
230: fnd_user fu,
231: fnd_responsibility fr
232: where furg.user_id = fu.user_id
233: and furg.responsibility_id = fr.responsibility_id
234: and furg.responsibility_application_id = fr.application_id