APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 3253: from ben_bnft_prvdd_ldgr_f bpl,

3249: cursor c_bpl ( c_acty_base_rt_id number ,
3250: c_bnft_prvdr_pool_id number ,
3251: c_prtt_enrt_rslt_id number) is
3252: select prvdd_val
3253: from ben_bnft_prvdd_ldgr_f bpl,
3254: ben_per_in_ler pil
3255: where bpl.acty_base_rt_id = c_acty_base_rt_id
3256: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
3257: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id

Line 3320: l_prvdd_val ben_bnft_prvdd_ldgr_f.prvdd_Val%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;
3324: l_correction boolean;