APPS.GHR_MASS_SEL_NOA dependencies on FND_SESSIONS

Line 4484: FROM fnd_sessions

4480: l_proc varchar2(72) DEFAULT 'GHR_MASS_CANCEL.'|| '.mcancel_process'; -- Bug# 14751973
4481: CURSOR get_sess_date IS
4482: SELECT trunc (effective_date)
4483: , session_id
4484: FROM fnd_sessions
4485: WHERE session_id = userenv ('sessionid');
4486: BEGIN
4487: hr_utility.set_location ('Entering mcancel_process '|| l_proc, 100);
4488:

Line 4578: INTO fnd_sessions (session_id, effective_date)

4574: hr_utility.set_location ('session id '|| userenv ('sessionid'), 100);
4575: l_session_id := userenv ('sessionid');
4576:
4577: INSERT
4578: INTO fnd_sessions (session_id, effective_date)
4579: VALUES (l_session_id, sysdate);
4580: ELSIF l_sess_date IS NULL THEN
4581: UPDATE fnd_sessions
4582: SET effective_date = trunc (sysdate)

Line 4581: UPDATE fnd_sessions

4577: INSERT
4578: INTO fnd_sessions (session_id, effective_date)
4579: VALUES (l_session_id, sysdate);
4580: ELSIF l_sess_date IS NULL THEN
4581: UPDATE fnd_sessions
4582: SET effective_date = trunc (sysdate)
4583: WHERE session_id = l_session_id;
4584: END IF;
4585: