eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_BENEFITS_EIT dependencies on FND_SESSIONS

Line 191: cursor c_session(c_session_id fnd_sessions.session_id%type) IS

187: l_ses_exist BOOLEAN;
188: l_life_event VARCHAR2(100);
189: l_cvrg_st_dt date;
190:
191: cursor c_session(c_session_id fnd_sessions.session_id%type) IS
192: SELECT 1 FROM fnd_sessions
193: where session_id = c_session_id;
194:
195: cursor c_get_ler_id is

Line 192: SELECT 1 FROM fnd_sessions

188: l_life_event VARCHAR2(100);
189: l_cvrg_st_dt date;
190:
191: cursor c_session(c_session_id fnd_sessions.session_id%type) IS
192: SELECT 1 FROM fnd_sessions
193: where session_id = c_session_id;
194:
195: cursor c_get_ler_id is
196: select ler_id from ben_ptnl_ler_for_per

Line 762: cursor c_session(c_session_id fnd_sessions.session_id%type) IS

758: l_Boolean BOOLEAN;
759: l_ses_exist BOOLEAN;
760: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
761:
762: cursor c_session(c_session_id fnd_sessions.session_id%type) IS
763: SELECT 1 FROM fnd_sessions
764: where session_id = c_session_id;
765:
766: BEGIN

Line 763: SELECT 1 FROM fnd_sessions

759: l_ses_exist BOOLEAN;
760: l_enrt_rt_id ben_enrt_rt.enrt_rt_id%type;
761:
762: cursor c_session(c_session_id fnd_sessions.session_id%type) IS
763: SELECT 1 FROM fnd_sessions
764: where session_id = c_session_id;
765:
766: BEGIN
767: