APPS.BEN_ELECTION_INFORMATION dependencies on BEN_ENRT_RT

Line 1078: from ben_enrt_rt er,

1074: er.ordr_num,
1075: eb.cvg_mlt_cd,
1076: abr.rate_periodization_rl, --GEVITY
1077: nvl(eb.mx_wo_ctfn_flag,'N') interim_flag --BUG 5502202
1078: from ben_enrt_rt er,
1079: ben_enrt_bnft eb,
1080: ben_acty_base_rt_f abr
1081: where er.enrt_rt_id=p_enrt_rt_id
1082: and eb.enrt_bnft_id(+)=er.enrt_bnft_id

Line 1353: FROM ben_enrt_rt er,

1349: IS
1350: SELECT abr.entr_val_at_enrt_flag, er.rt_mlt_cd,
1351: NVL (eb.entr_val_at_enrt_flag, 'N') entr_bnft_val_flag,
1352: eb.cvg_mlt_cd
1353: FROM ben_enrt_rt er,
1354: ben_enrt_bnft eb,
1355: ben_acty_base_rt_f abr,
1356: ben_prtt_enrt_rslt_f pen
1357: WHERE eb.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 1403: ,ben_enrt_rt ecr

1399: cursor c_get_elctbl_chc is
1400: select min(ecr.rt_strt_dt) rt_strt_dt
1401: ,epe.ptip_id
1402: from ben_elig_per_elctbl_chc epe
1403: ,ben_enrt_rt ecr
1404: ,ben_enrt_bnft enb
1405: where epe.per_in_ler_id = p_per_in_ler_id
1406: and epe.business_group_id = p_business_group_id
1407: and decode(ecr.enrt_bnft_id, null, ecr.elig_per_elctbl_chc_id,

Line 4377: from ben_enrt_rt ert

4373: -- cvg_mlt_cd of SAAEAR and enter value at enrollment is not checked.
4374: /*
4375: cursor c_ert is
4376: select ann_val
4377: from ben_enrt_rt ert
4378: where ert.enrt_bnft_id = p_enrt_bnft_id
4379: and ENTR_VAL_AT_ENRT_FLAG = 'N'
4380: and ann_val is not null ;
4381: l_ann_enrt_rt number ;

Line 4393: from ben_enrt_rt ert,

4389: abr.acty_base_rt_id,
4390: abr.rate_periodization_rl,
4391: enb.elig_per_elctbl_chc_id,
4392: ert.entr_ann_val_flag
4393: from ben_enrt_rt ert,
4394: ben_acty_base_rt_f abr,
4395: ben_enrt_bnft enb
4396: where enb.enrt_bnft_id = p_enrt_bnft_id
4397: and ert.enrt_bnft_id = enb.enrt_bnft_id

Line 4453: from ben_enrt_rt ecr

4449: --
4450: -- 5612091 - Added OR condition with p_elig_per_elctbl_chc_id
4451: cursor c_enrt_rt (p_acty_base_rt_id number) is
4452: select enrt_rt_id
4453: from ben_enrt_rt ecr
4454: where (ecr.enrt_bnft_id = p_enrt_bnft_id
4455: or ecr.ELIG_PER_ELCTBL_CHC_ID = p_elig_per_elctbl_chc_id)
4456: and ecr.acty_base_rt_id = p_acty_base_rt_id;
4457: --

Line 4558: from ben_enrt_rt ecr,

4554: select ecr.rt_strt_dt,
4555: ecr.rt_strt_dt_cd,
4556: ecr.rt_strt_dt_rl,
4557: nvl(ecr.elig_per_elctbl_chc_id,enb.elig_per_elctbl_chc_id) elig_per_elctbl_chc_id
4558: from ben_enrt_rt ecr,
4559: ben_enrt_bnft enb
4560: where ecr.prtt_rt_val_id = p_prtt_rt_val_id
4561: and ecr.enrt_bnft_id = enb.enrt_bnft_id (+) ;
4562: --

Line 5500: update ben_enrt_rt

5496: --
5497: open c_enrt_rt(l_acty_base_rt_id2);
5498: fetch c_enrt_rt into l_enrt_rt_id;
5499: if c_enrt_rt%found then
5500: update ben_enrt_rt
5501: set prtt_rt_val_id = l_prtt_rt_val_id
5502: where enrt_rt_id = l_enrt_rt_id;
5503: --
5504: if (g_debug) then