[Home] [Help]
1746: ,enb.ordr_num
1747: ,enb.dflt_val
1748: ,enb.comp_lvl_fctr_id
1749: ,enb.enrt_bnft_id
1750: from ben_enrt_bnft enb
1751: where enb.elig_per_elctbl_chc_id = p_bckdt_epe_id ;
1752: --
1753: cursor c_curr_enb is
1754: select enb.dflt_flag
1764: ,enb.ordr_num
1765: ,enb.dflt_val
1766: ,enb.comp_lvl_fctr_id
1767: ,enb.enrt_bnft_id
1768: from ben_enrt_bnft enb
1769: where enb.elig_per_elctbl_chc_id = p_curr_epe_id ;
1770: --
1771: TYPE l_bckdt_enb_rec is TABLE OF c_bckdt_enb%rowtype
1772: INDEX BY BINARY_INTEGER;
1784: --
1785: hr_utility.set_location ('Entering '||l_proc,10);
1786: --
1787: select count(*) into l_bckdt_enb_count
1788: from ben_enrt_bnft enb
1789: where enb.elig_per_elctbl_chc_id = p_bckdt_epe_id
1790: and enb.business_group_id = p_business_group_id;
1791: /*
1792: l_bckdt_enb_table.delete;
2099: --
2100: -- ben_elig_cvrd_dpnt_f
2101: -- ben_prtt_enrt_actn_f
2102: -- ben_elig_per_elctbl_chc -- 9999 done
2103: -- ben_enrt_bnft
2104: -- ben_enrt_rt
2105: -- ben_elctbl_chc_ctfn
2106: --
2107: cursor c_bckdt_epe_cnt is
2485: --
2486: -- ben_elig_cvrd_dpnt_f
2487: -- ben_prtt_enrt_actn_f
2488: -- ben_elig_per_elctbl_chc
2489: -- ben_enrt_bnft
2490: -- ben_enrt_rt
2491: -- ben_elctbl_chc_ctfn
2492: --
2493: cursor c_bckdt_epe_cnt is
6291: enb.dflt_val,
6292: enb.val,
6293: enb.dflt_flag,
6294: enb.cvg_mlt_cd --Bug 3315323
6295: from ben_enrt_bnft enb
6296: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
6297: -- Bug 2526994 we need take the right one
6298: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
6299: and enb.ordr_num = cp_ordr_num ; --This is more accurate
8062: enb.dflt_val,
8063: enb.val,
8064: enb.dflt_flag,
8065: enb.cvg_mlt_cd --Bug 3315323
8066: from ben_enrt_bnft enb
8067: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
8068: -- Bug 2526994 we need take the right one
8069: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
8070: and enb.ordr_num = cp_ordr_num ; --This is more accurate
8223:
8224: cursor c_interim_bnft(p_elig_per_elctbl_chc_id number) is
8225: select enb.val bnft_amt,
8226: enb.enrt_bnft_id
8227: from ben_enrt_bnft enb
8228: where enb.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
8229: --Bug 14059090
8230: and ((l_susp_interim_same_epe = 'Y' and enb.ordr_num in (0))
8231: or (l_susp_interim_same_epe = 'N' and enb.ordr_num in (-1,1)))
8306: epe.object_version_number
8307: from
8308: ben_elig_per_elctbl_chc epe,
8309: ben_prtt_enrt_rslt_f pen,
8310: ben_enrt_bnft bnft
8311: where pen.per_in_ler_id = c_prev_pil_id
8312: and pen.pl_id = epe.pl_id
8313: and pen.pgm_id = epe.pgm_id
8314: and pen.pl_typ_id = epe.pl_typ_id
9489: cursor c_enb_enrt_rt(v_elig_per_elctbl_chc_id number,
9490: v_acty_base_rt_id number) is
9491: select ecr.enrt_bnft_id
9492: from ben_enrt_rt ecr,
9493: ben_enrt_bnft enb
9494: where enb.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
9495: and enb.ordr_num > 0 --9999 Need to check this
9496: and ecr.enrt_bnft_id = enb.enrt_bnft_id
9497: and ecr.acty_base_rt_id = v_acty_base_rt_id ;
11605: enb.dflt_flag,
11606: enb.object_version_number,
11607: enb.prtt_enrt_rslt_id,
11608: enb.cvg_mlt_cd --Bug 3315323
11609: from ben_enrt_bnft enb
11610: where enb.elig_per_elctbl_chc_id = cp_elig_per_elctbl_chc_id
11611: -- Bug 2526994 we need take the right one
11612: -- and nvl(enb.mx_wo_ctfn_flag,'N') = 'N' ;
11613: and enb.ordr_num = cp_ordr_num ; --This is more accurate
12140: end if ;
12141:
12142: if l_bnft_rec.prtt_enrt_rslt_id is not null then
12143: l_object_version_number := l_bnft_rec.object_version_number ;
12144: ben_enrt_bnft_api.update_enrt_bnft
12145: (p_enrt_bnft_id => l_bnft_rec.enrt_bnft_id
12146: ,p_effective_date => p_effective_date
12147: ,p_object_version_number => l_object_version_number
12148: ,p_business_group_id => p_business_group_id