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.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 109: from ben_elig_per_elctbl_chc epe,

105: --
106: */
107: cursor c_sspndd_enrts is
108: select epe.elig_per_elctbl_chc_id, epe.object_version_number -- 3638279: Added ovn;
109: from ben_elig_per_elctbl_chc epe,
110: ben_prtt_enrt_rslt_f pen
111: where pen.person_id = p_person_id
112: and pen.per_in_ler_id = p_per_in_ler_id
113: and epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 131: from ben_elig_per_elctbl_chc

127: */
128: --
129: cursor c_elig_per_elctbl_chc is
130: select object_version_number
131: from ben_elig_per_elctbl_chc
132: where elig_per_elctbl_chc_id = l_pending;
133: --
134: cursor c_elig_per_elctbl_chc_2 is
135: select elig_per_elctbl_chc_id,

Line 137: from ben_elig_per_elctbl_chc

133: --
134: cursor c_elig_per_elctbl_chc_2 is
135: select elig_per_elctbl_chc_id,
136: object_version_number
137: from ben_elig_per_elctbl_chc
138: where per_in_ler_id = p_per_in_ler_id
139: and in_pndg_wkflow_flag = 'Y';
140: --
141: cursor c_elig_per_elctbl_chc_3 is

Line 144: from ben_elig_per_elctbl_chc

140: --
141: cursor c_elig_per_elctbl_chc_3 is
142: select elig_per_elctbl_chc_id,
143: object_version_number
144: from ben_elig_per_elctbl_chc
145: where per_in_ler_id = p_per_in_ler_id
146: and in_pndg_wkflow_flag <> 'Y'
147: and pil_elctbl_chc_popl_id in
148: (select pil_elctbl_chc_popl_id

Line 153: from ben_elig_per_elctbl_chc epe

149: from ben_pil_elctbl_chc_popl pel
150: where pel.per_in_ler_id = p_per_in_ler_id and
151: exists
152: ( select null
153: from ben_elig_per_elctbl_chc epe
154: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
155: and nvl(epe.in_pndg_wkflow_flag,'N') in ('Y', 'S') ));
156: --
157: l_object_version_number number;

Line 224: update ben_elig_per_elctbl_chc

220: );
221: --
222: /*
223: hr_utility.set_location ('sspndd epe = '||l_epe_rec.elig_per_elctbl_chc_id,20);
224: update ben_elig_per_elctbl_chc
225: set in_pndg_wkflow_flag = 'S'
226: where elig_per_elctbl_chc_id = l_epe_rec.elig_per_elctbl_chc_id;
227: */
228: --

Line 266: type epetab is table of ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type;

262: is
263: --
264: l_rec benutils.g_active_life_event;
265:
266: type epetab is table of ben_elig_per_elctbl_chc.elig_per_elctbl_chc_id%type;
267: t_epe_tbl epetab;
268:
269: l_object_version_number number ;
270: l_package varchar2(100):= 'delete_elctbl_choice';

Line 278: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

274: cursor c_enrt_rt is
275: select *
276: from ben_enrt_rt
277: where elig_per_elctbl_chc_id in
278: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
279: where per_in_ler_id = p_rec.per_in_ler_id)
280: union
281: select *
282: from ben_enrt_rt

Line 286: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

282: from ben_enrt_rt
283: where enrt_bnft_id in
284: (select enrt_bnft_id from ben_enrt_bnft
285: where elig_per_elctbl_chc_id in
286: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
287: where per_in_ler_id = p_rec.per_in_ler_id));
288: */
289: --
290: cursor c_pil_popl is

Line 303: from ben_elig_per_elctbl_chc epe

299: and pl_id is not null;
300: --
301: cursor c_epe(p_per_in_ler_id number) is
302: select epe.elig_per_elctbl_chc_id
303: from ben_elig_per_elctbl_chc epe
304: where epe.per_in_ler_id = p_per_in_ler_id
305: and epe.pil_elctbl_chc_popl_id in
306: (select pel.pil_elctbl_chc_popl_id
307: from ben_pil_elctbl_chc_popl pel

Line 311: from ben_elig_per_elctbl_chc epe2

307: from ben_pil_elctbl_chc_popl pel
308: where pel.per_in_ler_id = p_per_in_ler_id
309: and not exists
310: (select null
311: from ben_elig_per_elctbl_chc epe2
312: where pel.pil_elctbl_chc_popl_id=epe2.pil_elctbl_chc_popl_id
313: and nvl(epe2.in_pndg_wkflow_flag,'N') in ('Y', 'S')));
314: --
315: cursor c_epe_ch (p_elig_per_elctbl_chc_id number) is

Line 369: from ben_elig_per_elctbl_chc

365: ,APPROVAL_STATUS_CD
366: ,elig_per_elctbl_chc_id
367: ,object_version_number
368: ,null mark_delete
369: from ben_elig_per_elctbl_chc
370: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
371: --
372: cursor c_enb_ch (p_elig_per_elctbl_chc_id number) is
373: select enrt_bnft_id

Line 559: delete from ben_elig_per_elctbl_chc

555: delete from ben_elig_dpnt
556: where elig_per_elctbl_chc_id = t_epe_tbl(i);
557:
558: forall i in 1..t_epe_tbl.last
559: delete from ben_elig_per_elctbl_chc
560: where elig_per_elctbl_chc_id = t_epe_tbl(i);
561: */
562: for i in 1..t_epe_tbl.last loop
563: hr_utility.set_location (' within loop'||t_epe_tbl(i),10);

Line 567: update ben_elig_per_elctbl_chc set prtt_enrt_rslt_id = null

563: hr_utility.set_location (' within loop'||t_epe_tbl(i),10);
564: open c_epe_ch (t_epe_tbl(i));
565: fetch c_epe_ch into g_unrest_epe_instance(i);
566: --
567: update ben_elig_per_elctbl_chc set prtt_enrt_rslt_id = null
568: where elig_per_elctbl_chc_id = t_epe_tbl(i);
569: --
570: close c_epe_ch;
571: end loop;

Line 663: from ben_elig_per_elctbl_chc epe

659: delete from ben_pil_elctbl_chc_popl pel
660: where per_in_ler_id = p_rec.per_in_ler_id
661: and not exists
662: (select null
663: from ben_elig_per_elctbl_chc epe
664: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
665: and nvl(epe.in_pndg_wkflow_flag,'N') in ('Y', 'S') ) ;
666: --
667: -- Reset back 'Z' value of the in_pndg_wkflow_flag to 'N'.

Line 672: update ben_elig_per_elctbl_chc

668: -- As it was just used to suppress the deletion of electable choice
669: -- data associated with the suspended enrollments.
670: --
671: /*
672: update ben_elig_per_elctbl_chc
673: set in_pndg_wkflow_flag = 'N'
674: where in_pndg_wkflow_flag = 'Z'
675: and per_in_ler_id = p_rec.per_in_ler_id;
676: */

Line 1905: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =

1901: --
1902: if g_unrest_epe_instance(i).mark_delete is null then
1903: --
1904: hr_utility.set_location ('Delete Elig Id '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);
1905: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =
1906: g_unrest_epe_instance(i).elig_per_elctbl_chc_id;
1907: --
1908: end if;
1909: --

Line 1939: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =

1935: and g_unrest_epe_instance(i).comp_lvl_cd in ('OIPL','PLAN') then
1936: -- and g_unrest_epe_instance(i).elctbl_flag = 'Y' -- bug 4761065 : Need to delete epe regardless whether its elctbl_flag is Y/N .
1937: --
1938: hr_utility.set_location ('Delete Elig Id in clear_epe '||g_unrest_epe_instance(i).elig_per_elctbl_chc_id,11);
1939: delete from ben_elig_per_elctbl_chc where elig_per_elctbl_chc_id =
1940: g_unrest_epe_instance(i).elig_per_elctbl_chc_id;
1941: --
1942: else
1943: --