APPS.BEN_MANAGE_UNRES_LIFE_EVENTS dependencies on BEN_ENRT_BNFT

Line 286: (select enrt_bnft_id from ben_enrt_bnft

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

Line 380: from ben_enrt_bnft

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

Line 401: from ben_enrt_bnft

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

Line 538: from ben_enrt_bnft

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

Line 549: from ben_enrt_bnft

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

Line 553: delete from ben_enrt_bnft

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

Line 975: ben_enrt_bnft_api.update_enrt_bnft

971: end loop;
972: --
973: end if;
974: --
975: ben_enrt_bnft_api.update_enrt_bnft
976: (p_enrt_bnft_id => p_enrt_bnft_id
977: ,p_dflt_flag => p_dflt_flag
978: ,p_val_has_bn_prortd_flag => p_val_has_bn_prortd_flag
979: ,p_bndry_perd_cd => p_bndry_perd_cd

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

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