APPS.HR_GENERAL2 dependencies on FND_SESSIONS

Line 277: FROM fnd_sessions se

273: end if;
274: -- Get the session date
275: SELECT se.effective_date
276: INTO l_session_date
277: FROM fnd_sessions se
278: WHERE se.session_id =USERENV('sessionid');
279:
280: -- Query to detect duplicate person
281: -- Use where exists for performance reasons

Line 390: FROM fnd_sessions se

386: end if;
387: -- Get the session date
388: SELECT se.effective_date
389: INTO l_session_date
390: FROM fnd_sessions se
391: WHERE se.session_id =USERENV('sessionid');
392:
393: -- Query to detect duplicate person
394: -- Use where exists for performance reasons

Line 1355: FROM fnd_sessions se

1351: hr_utility.set_location('3',10);
1352: -- Get the session date
1353: SELECT se.effective_date
1354: INTO l_session_date
1355: FROM fnd_sessions se
1356: WHERE se.session_id =USERENV('sessionid');
1357:
1358: -- Query to detect duplicate person
1359: -- Use where exists for performance reasons

Line 1513: FROM fnd_sessions se

1509:
1510: -- Get the session date
1511: SELECT se.effective_date
1512: INTO l_session_date
1513: FROM fnd_sessions se
1514: WHERE se.session_id = USERENV('sessionid');
1515:
1516:
1517: hr_utility.set_location('SSHR',10);