APPS.MSC_PHUB_UTIL dependencies on FND_USER

Line 203: from fnd_user u, fnd_user_resp_groups g

199: l_user_name varchar2(80);
200: begin
201: select distinct u.user_name
202: into l_user_name
203: from fnd_user u, fnd_user_resp_groups g
204: where u.user_id=g.user_id
205: and g.responsibility_application_id=724
206: and sysdate between u.start_date and nvl(u.end_date, sysdate)
207: and u.user_id=p_user_id;

Line 307: from fnd_user_resp_groups furg,

303: SECURITY_CONTEXT_INVALID exception;
304:
305: cursor c_user_info is
306: select furg.user_id, furg.responsibility_id, responsibility_application_id
307: from fnd_user_resp_groups furg,
308: fnd_user fu,
309: fnd_responsibility fr
310: where furg.user_id = fu.user_id
311: and furg.responsibility_id = fr.responsibility_id

Line 308: fnd_user fu,

304:
305: cursor c_user_info is
306: select furg.user_id, furg.responsibility_id, responsibility_application_id
307: from fnd_user_resp_groups furg,
308: fnd_user fu,
309: fnd_responsibility fr
310: where furg.user_id = fu.user_id
311: and furg.responsibility_id = fr.responsibility_id
312: and furg.responsibility_application_id = fr.application_id