[Home] [Help]
3126: l_object_version_number ben_prtt_enrt_rslt_f.object_version_number%TYPE;
3127: l_effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
3128: l_effective_end_date ben_prtt_enrt_rslt_f.effective_end_date%TYPE;
3129: l_prev_bnft_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
3130: l_enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%TYPE;
3131: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;
3132: l_chg boolean := FALSE;
3133: l_step number(9);
3134: l_datetrack_mode varchar2(30) := p_datetrack_mode;
6051: ,ben_elig_per_elctbl_chc epe
6052: ,ben_per_in_ler pil
6053: ,ben_enrt_bnft enb
6054: ,ben_oipl_f oipl
6055: ,ben_pl_f pl
6056: ,ben_opt_f opt
6057: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6058: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)
6059: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
10128: -- BUG: 3904792: MAINLINE FIX FOR 3894240: WHEN UPDATING A SAVINGS PLAN RATE SYSTEM IS END DATE
10129: AND NOT EXISTS
10130: (SELECT NULL
10131: FROM ben_ler_f ler,
10132: ben_pl_f pln
10133: WHERE ler.ler_id = r.ler_id
10134: AND ler.typ_cd = 'SCHEDDU'
10135: AND pln.SVGS_PL_FLAG = 'Y'
10136: and pln.pl_id = r.pl_id
10177: --
10178: cursor pl_typ_c is
10179: select distinct pln.pl_typ_id
10180: from ben_pil_elctbl_chc_popl pel,
10181: ben_pl_f pln
10182: where pel.per_in_ler_id = p_per_in_ler_id
10183: and pel.pgm_id is null
10184: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
10185: and pln.pl_id = nvl(pel.pl_id, -1)
10306: ,pl.bnf_dsgn_cd
10307: From ben_prtt_enrt_rslt_f r,
10308: ben_elig_per_elctbl_chc c,
10309: ben_per_in_ler pil,
10310: ben_pl_f pl
10311: Where r.pl_typ_id = p_pl_typ_id
10312: and r.per_in_ler_id = p_per_in_ler_id
10313: and r.pgm_id = p_pgm_id
10314: and r.person_id = p_person_id