APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_RT

Line 278: from ben_enrt_rt

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

Line 284: from ben_enrt_rt

280: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc
281: where per_in_ler_id = p_rec.per_in_ler_id)
282: union
283: select *
284: from ben_enrt_rt
285: where enrt_bnft_id in
286: (select enrt_bnft_id from ben_enrt_bnft
287: where elig_per_elctbl_chc_id in
288: (select elig_per_elctbl_chc_id from ben_elig_per_elctbl_chc

Line 390: from ben_enrt_rt

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

Line 399: from ben_enrt_rt

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

Line 531: delete from ben_enrt_rt

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

Line 535: delete from ben_enrt_rt

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

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

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