APPS.FND_SESSION_MANAGEMENT dependencies on FND_USER

Line 236: FROM fnd_user

232:
233: BEGIN
234: SELECT user_name
235: INTO l_user_name
236: FROM fnd_user
237: WHERE user_id=l_user_id;
238: EXCEPTION
239: WHEN OTHERS THEN
240: WF_CORE.CONTEXT('fnd_session_management', 'doNewSessionEvent',p_evtMsg.getEventName( ), p_guid);

Line 431: FROM fnd_user

427: l_guest_username := UPPER(SUBSTR(l_guest_username,1,INSTR(l_guest_username,'/') -1));
428: BEGIN
429: SELECT user_id
430: INTO l_guest_user_id
431: FROM fnd_user
432: WHERE user_name = l_guest_username;
433: EXCEPTION
434: WHEN no_data_found THEN
435: l_guest_user_id := -999;

Line 655: select user_id into l_user_id from fnd_user

651: FND_LOG.STRING(FND_LOG.LEVEL_PROCEDURE , l_module, 'BEGIN');
652: end if;
653: -- check if user exists
654: begin
655: select user_id into l_user_id from fnd_user
656: where user_id = p_user_id and
657: (start_date <= sysdate) and
658: (end_date is null or end_date>sysdate);
659: exception

Line 701: FROM fnd_user

697: l_guest_username := UPPER(SUBSTR(l_guest_username,1,INSTR(l_guest_username,'/') -1));
698: BEGIN
699: SELECT user_id
700: INTO l_guest_user_id
701: FROM fnd_user
702: WHERE user_name = l_guest_username;
703: EXCEPTION
704: WHEN no_data_found THEN
705: l_guest_user_id := -999;

Line 1577: fnd_user b

1573: then
1574: select b.USER_NAME
1575: into n_id
1576: from icx_sessions a,
1577: fnd_user b
1578: where b.user_id = a.user_id
1579: and a.session_id = p_session_id;
1580:
1581: elsif n_param = PV_USER_ID --** WEB USER ID (10) **