APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_BNFT

Line 284: (select enrt_bnft_id from ben_enrt_bnft

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
287: where per_in_ler_id = p_rec.per_in_ler_id));
288: */

Line 378: from ben_enrt_bnft

374: ,ELIG_PER_ELCTBL_CHC_ID
375: ,ORDR_NUM
376: ,OBJECT_VERSION_NUMBER
377: ,null mark_delete
378: from ben_enrt_bnft
379: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id;
380: --
381: cursor c_ecr_ch (p_elig_per_elctbl_chc_id number) is
382: select enrt_rt_id

Line 399: from ben_enrt_bnft

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: );
402: --
403: cursor c_epr_ch (p_elig_per_elctbl_chc_id number) is

Line 536: from ben_enrt_bnft

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));
538:
539: forall i in 1..t_epe_tbl.last
540: delete from ben_elctbl_chc_ctfn

Line 547: from ben_enrt_bnft

543: forall i in 1..t_epe_tbl.last
544: delete from ben_elctbl_chc_ctfn
545: where enrt_bnft_id in
546: (select enrt_bnft_id
547: from ben_enrt_bnft
548: where elig_per_elctbl_chc_id = t_epe_tbl(i));
549:
550: forall i in 1..t_epe_tbl.last
551: delete from ben_enrt_bnft

Line 551: delete from ben_enrt_bnft

547: from ben_enrt_bnft
548: where elig_per_elctbl_chc_id = t_epe_tbl(i));
549:
550: forall i in 1..t_epe_tbl.last
551: delete from ben_enrt_bnft
552: where elig_per_elctbl_chc_id = t_epe_tbl(i);
553:
554: forall i in 1..t_epe_tbl.last
555: delete from ben_elig_dpnt

Line 972: ben_enrt_bnft_api.update_enrt_bnft

968: end loop;
969: --
970: end if;
971: --
972: ben_enrt_bnft_api.update_enrt_bnft
973: (p_enrt_bnft_id => p_enrt_bnft_id
974: ,p_dflt_flag => p_dflt_flag
975: ,p_val_has_bn_prortd_flag => p_val_has_bn_prortd_flag
976: ,p_bndry_perd_cd => p_bndry_perd_cd

Line 1876: delete from ben_enrt_bnft where enrt_bnft_id = g_unrest_enb_instance(i).enrt_bnft_id;

1872: for i in g_unrest_enb_instance.first..g_unrest_enb_instance.last loop
1873: --
1874: if g_unrest_enb_instance(i).mark_delete is null then
1875: --
1876: delete from ben_enrt_bnft where enrt_bnft_id = g_unrest_enb_instance(i).enrt_bnft_id;
1877: --
1878: end if;
1879: --
1880: end loop;