DBA Data[Home] [Help]

APPS.BEN_DERIVE_PART_AND_RATE_CVG dependencies on BEN_AGE_RT_F

Line 682: ben_age_rt_f art,

678: agf.age_calc_rl,
679: agf.mn_age_num,
680: agf.mx_age_num
681: from ben_age_fctr agf,
682: ben_age_rt_f art,
683: ben_vrbl_rt_prfl_f vpf,
684: ben_bnft_vrbl_rt_f avr,
685: ben_cvg_amt_calc_mthd_f abr
686: where abr.pl_id = p_pl_id

Line 871: ben_age_rt_f art,

867: agf.age_calc_rl,
868: agf.mn_age_num,
869: agf.mx_age_num
870: from ben_age_fctr agf,
871: ben_age_rt_f art,
872: ben_vrbl_rt_prfl_f vpf,
873: ben_bnft_vrbl_rt_f avr,
874: ben_cvg_amt_calc_mthd_f abr
875: where abr.oipl_id = p_oipl_id

Line 1062: ben_age_rt_f art,

1058: agf.mx_age_num
1059: from ben_cvg_amt_calc_mthd_f abr,
1060: ben_bnft_vrbl_rt_f avr,
1061: ben_vrbl_rt_prfl_f vpf,
1062: ben_age_rt_f art,
1063: ben_age_fctr agf
1064: where abr.plip_id = p_plip_id
1065: and p_effective_date
1066: between abr.effective_start_date