[Home] [Help]
3315: l_object_version_number ben_prtt_enrt_rslt_f.object_version_number%TYPE;
3316: l_effective_start_date ben_prtt_enrt_rslt_f.effective_start_date%TYPE;
3317: l_effective_end_date ben_prtt_enrt_rslt_f.effective_end_date%TYPE;
3318: l_prev_bnft_amt ben_prtt_enrt_rslt_f.bnft_amt%TYPE;
3319: l_enrt_pl_opt_flag ben_pl_f.enrt_pl_opt_flag%TYPE;
3320: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%type ;
3321: l_chg boolean := FALSE;
3322: l_step number(9);
3323: l_datetrack_mode varchar2(30) := p_datetrack_mode;
6340: ,ben_elig_per_elctbl_chc epe
6341: ,ben_per_in_ler pil
6342: ,ben_enrt_bnft enb
6343: ,ben_oipl_f oipl
6344: ,ben_pl_f pl
6345: ,ben_opt_f opt
6346: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
6347: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)
6348: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)
11726: -- BUG: 3904792: MAINLINE FIX FOR 3894240: WHEN UPDATING A SAVINGS PLAN RATE SYSTEM IS END DATE
11727: AND NOT EXISTS
11728: (SELECT NULL
11729: FROM ben_ler_f ler,
11730: ben_pl_f pln
11731: WHERE ler.ler_id = r.ler_id
11732: AND ler.typ_cd = 'SCHEDDU'
11733: AND pln.SVGS_PL_FLAG = 'Y'
11734: and pln.pl_id = r.pl_id
11775: --
11776: cursor pl_typ_c is
11777: select distinct pln.pl_typ_id
11778: from ben_pil_elctbl_chc_popl pel,
11779: ben_pl_f pln
11780: where pel.per_in_ler_id = p_per_in_ler_id
11781: and pel.pgm_id is null
11782: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)
11783: and pln.pl_id = nvl(pel.pl_id, -1)
11904: ,pl.bnf_dsgn_cd
11905: From ben_prtt_enrt_rslt_f r,
11906: ben_elig_per_elctbl_chc c,
11907: ben_per_in_ler pil,
11908: ben_pl_f pl
11909: Where r.pl_typ_id = p_pl_typ_id
11910: and r.per_in_ler_id = p_per_in_ler_id
11911: and r.pgm_id = p_pgm_id
11912: and r.person_id = p_person_id