285: end if;
286: -- Get the session date
287: SELECT se.effective_date
288: INTO l_session_date
289: FROM fnd_sessions se
290: WHERE se.session_id =USERENV('sessionid');
291:
292: -- Query to detect duplicate person
293: -- Use where exists for performance reasons
398: end if;
399: -- Get the session date
400: SELECT se.effective_date
401: INTO l_session_date
402: FROM fnd_sessions se
403: WHERE se.session_id =USERENV('sessionid');
404:
405: -- Query to detect duplicate person
406: -- Use where exists for performance reasons
1405: hr_utility.set_location('3',10);
1406: -- Get the session date
1407: SELECT se.effective_date
1408: INTO l_session_date
1409: FROM fnd_sessions se
1410: WHERE se.session_id =USERENV('sessionid');
1411:
1412: -- Query to detect duplicate person
1413: -- Use where exists for performance reasons
1563:
1564: -- Get the session date
1565: SELECT se.effective_date
1566: INTO l_session_date
1567: FROM fnd_sessions se
1568: WHERE se.session_id = USERENV('sessionid');
1569:
1570:
1571: hr_utility.set_location('SSHR',10);