APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_RT

Line 276: from ben_enrt_rt

272: --
273: /*
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

Line 282: from ben_enrt_rt

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
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

Line 388: from ben_enrt_rt

384: ,ENRT_BNFT_ID
385: ,OBJECT_VERSION_NUMBER
386: ,ACTY_BASE_RT_ID
387: ,null mark_delete
388: from ben_enrt_rt
389: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
390: union
391: select enrt_rt_id
392: ,ELIG_PER_ELCTBL_CHC_ID

Line 397: from ben_enrt_rt

393: ,ENRT_BNFT_ID
394: ,OBJECT_VERSION_NUMBER
395: ,ACTY_BASE_RT_ID
396: ,null mark_delete
397: from ben_enrt_rt
398: where enrt_bnft_id in (select enrt_bnft_id
399: from ben_enrt_bnft
400: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
401: );

Line 529: delete from ben_enrt_rt

525: hr_utility.set_location('epe count'|| t_epe_tbl.count,10);
526: if t_epe_tbl.count > 0 then
527: /*
528: forall i in 1..t_epe_tbl.last
529: delete from ben_enrt_rt
530: where elig_per_elctbl_chc_id = t_epe_tbl(i);
531:
532: forall i in 1..t_epe_tbl.last
533: delete from ben_enrt_rt

Line 533: delete from ben_enrt_rt

529: delete from ben_enrt_rt
530: where elig_per_elctbl_chc_id = t_epe_tbl(i);
531:
532: forall i in 1..t_epe_tbl.last
533: delete from ben_enrt_rt
534: where enrt_bnft_id in
535: (select enrt_bnft_id
536: from ben_enrt_bnft
537: where elig_per_elctbl_chc_id = t_epe_tbl(i));

Line 1833: delete from ben_enrt_rt where enrt_rt_id = g_unrest_ecr_instance(i).enrt_rt_id;

1829: for i in g_unrest_ecr_instance.first..g_unrest_ecr_instance.last loop
1830: --
1831: if g_unrest_ecr_instance(i).mark_delete is null then
1832: --
1833: delete from ben_enrt_rt where enrt_rt_id = g_unrest_ecr_instance(i).enrt_rt_id;
1834: --
1835: end if;
1836: --
1837: end loop;