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:

Line 1099: CURSOR c_session(c_session_id fnd_sessions.session_id%type) is

1095: AND pil.per_in_ler_id = chc.per_in_ler_id
1096: AND pil.ler_id = c_ler_id
1097: AND pil.person_id = c_person_id;
1098:
1099: CURSOR c_session(c_session_id fnd_sessions.session_id%type) is
1100: SELECT 1
1101: FROM fnd_sessions
1102: WHERE session_id = c_session_id;
1103:

Line 1101: FROM fnd_sessions

1097: AND pil.person_id = c_person_id;
1098:
1099: CURSOR c_session(c_session_id fnd_sessions.session_id%type) is
1100: SELECT 1
1101: FROM fnd_sessions
1102: WHERE session_id = c_session_id;
1103:
1104: CURSOR c_get_ler_id(c_effective_date date) is
1105: SELECT ler_id

Line 1119: SELECT 1 from ben_lee_rsn_f r, ben_popl_enrt_typ_cycl_f p, fnd_sessions se

1115:
1116: CURSOR c_chk_le_exists(p_pgm_id in number,
1117: p_ler_id in number)
1118: is
1119: SELECT 1 from ben_lee_rsn_f r, ben_popl_enrt_typ_cycl_f p, fnd_sessions se
1120: WHERE se.session_id = userenv('sessionid')
1121: AND r.popl_enrt_typ_cycl_id = p.popl_enrt_typ_cycl_id
1122: AND r.business_group_id = p.business_group_id
1123: AND p.pgm_id = p_pgm_id