APPS.HR_INTEGRATION_UTILS dependencies on FND_SESSIONS

Line 226: FROM fnd_sessions

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

Line 242: INSERT INTO fnd_sessions (session_id, effective_date)

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

Line 251: UPDATE fnd_sessions

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