APPS.HR_INTEGRATION_UTILS dependencies on FND_SESSIONS

Line 227: FROM fnd_sessions

223: PRAGMA AUTONOMOUS_TRANSACTION;
224: --
225: CURSOR csr_find_row IS
226: SELECT 'Y'
227: FROM fnd_sessions
228: WHERE session_id = userenv('sessionid');
229: --
230: l_exists varchar2(1);
231: BEGIN

Line 243: INSERT INTO fnd_sessions (session_id, effective_date)

239: --
240: hr_utility.set_location('ADD_OR_UPDATE_SESSION - NO ROW',20);
241: --
242: -- Row does not exist, so add
243: INSERT INTO fnd_sessions (session_id, effective_date)
244: VALUES (userenv('sessionid'), p_sess_date);
245: --
246: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW ADDED',30);
247: --

Line 252: UPDATE fnd_sessions

248: ELSE
249: --
250: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW EXISTS',40);
251: -- Row exists, so update date
252: UPDATE fnd_sessions
253: SET effective_date = p_sess_date
254: WHERE session_id = userenv('sessionid');
255: hr_utility.set_location('ADD_OR_UPDATE_SESSION - ROW UPDATE',50);
256: --