APPS.GHR_POI_FLEX_DDF dependencies on DUAL

Line 97: where session_id = (select userenv('sessionid') from dual);

93: pos.effective_end_date;
94: cursor c_get_session_date is
95: select trunc(effective_date) session_date
96: from fnd_sessions
97: where session_id = (select userenv('sessionid') from dual);
98:
99: l_session_date date;
100: Begin
101: hr_utility.set_location('Entering:'||l_proc, 5);

Line 245: where session_id = (select userenv('sessionid') from dual);

241: and pos.effective_end_date;
242: cursor c_get_session_date is
243: select trunc(effective_date) session_date
244: from fnd_sessions
245: where session_id = (select userenv('sessionid') from dual);
246: l_session_date date;
247: Begin
248: hr_utility.set_location('Entering:'||l_proc, 5);
249: