APPS.GHR_ELT_TO_BEN_PKG dependencies on DUAL

Line 257: FROM dual;

253: AND batch_no = c_batch_no;
254:
255: CURSOR c_sessionid is
256: SELECT userenv('sessionid') sesid
257: FROM dual;
258:
259: -- Cursor to pick the History Rows for a given Person ID
260: CURSOR c_person_history(p_person_id NUMBER) IS
261: SELECT *

Line 2393: select userenv('sessionid') INTO l_session_id from dual;

2389: l_session_var.date_effective := trunc(l_calculated_date);
2390: l_session_var.fire_trigger := 'Y';
2391: ghr_history_api.set_g_session_var (l_session_var);
2392:
2393: select userenv('sessionid') INTO l_session_id from dual;
2394: open get_sess_date;
2395: fetch get_sess_date into l_sess_date;
2396: IF get_sess_date%NOTFOUND THEN
2397: INSERT INTO fnd_sessions(SESSION_ID,EFFECTIVE_DATE)