APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_BNFT_PRVDD_LDGR_F

Line 3064: from ben_bnft_prvdd_ldgr_f bpl,

3060: cursor c_bpl ( c_acty_base_rt_id number ,
3061: c_bnft_prvdr_pool_id number ,
3062: c_prtt_enrt_rslt_id number) is
3063: select prvdd_val
3064: from ben_bnft_prvdd_ldgr_f bpl,
3065: ben_per_in_ler pil
3066: where bpl.acty_base_rt_id = c_acty_base_rt_id
3067: and bpl.bnft_prvdr_pool_id = c_bnft_prvdr_pool_id
3068: and bpl.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id

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