APPS.GHR_POI_FLEX_DDF dependencies on FND_SESSIONS

Line 85: cursor c_pos_segments(p_session_date in fnd_sessions.effective_date%type) is

81: l_proc varchar2(72) := g_package||'ddf';
82: l_error exception;
83: l_date_from date;
84: --
85: cursor c_pos_segments(p_session_date in fnd_sessions.effective_date%type) is
86: select information6,segment1,segment2,segment3,segment4,
87: segment5,segment6,segment7
88: from per_position_definitions pdf, hr_all_positions_f pos
89: where

Line 96: from fnd_sessions

92: and p_session_date between pos.effective_start_date and
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

Line 244: from fnd_sessions

240: and p_session_date between pos.effective_start_date
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);