APPS.BEN_DERIVE_PART_AND_RATE_CVG dependencies on BEN_BNFT_VRBL_RT_F

Line 63: ben_bnft_vrbl_rt_f avr,

59: lsf.mx_los_num
60: from ben_los_fctr lsf,
61: ben_los_rt_f lsr,
62: ben_vrbl_rt_prfl_f vpf,
63: ben_bnft_vrbl_rt_f avr,
64: ben_cvg_amt_calc_mthd_f abr
65: where abr.pl_id = p_pl_id
66: and abr.business_group_id = p_business_group_id
67: and p_effective_date

Line 252: ben_bnft_vrbl_rt_f avr,

248: lsf.mx_los_num
249: from ben_los_fctr lsf,
250: ben_los_rt_f lsr,
251: ben_vrbl_rt_prfl_f vpf,
252: ben_bnft_vrbl_rt_f avr,
253: ben_cvg_amt_calc_mthd_f abr
254: where abr.oipl_id = p_oipl_id
255: and abr.business_group_id = p_business_group_id
256: and p_effective_date

Line 444: ben_bnft_vrbl_rt_f avr,

440: lsf.mx_los_num
441: from ben_los_fctr lsf,
442: ben_los_rt_f lsr,
443: ben_vrbl_rt_prfl_f vpf,
444: ben_bnft_vrbl_rt_f avr,
445: ben_cvg_amt_calc_mthd_f abr
446: where abr.plip_id = p_plip_id
447: and abr.business_group_id = p_business_group_id
448: and p_effective_date

Line 684: ben_bnft_vrbl_rt_f avr,

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
687: and abr.business_group_id = p_business_group_id
688: and p_effective_date

Line 873: ben_bnft_vrbl_rt_f avr,

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
876: and abr.business_group_id = p_business_group_id
877: and p_effective_date

Line 1060: ben_bnft_vrbl_rt_f avr,

1056: agf.age_calc_rl,
1057: agf.mn_age_num,
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

Line 1301: ben_bnft_vrbl_rt_f avr,

1297: clf.comp_calc_rl
1298: from ben_comp_lvl_fctr clf,
1299: ben_comp_lvl_rt_f clr,
1300: ben_vrbl_rt_prfl_f vpf,
1301: ben_bnft_vrbl_rt_f avr,
1302: ben_cvg_amt_calc_mthd_f abr
1303: where abr.pl_id = p_pl_id
1304: and abr.business_group_id = p_business_group_id
1305: and p_effective_date

Line 1494: ben_bnft_vrbl_rt_f avr,

1490: clf.comp_calc_rl
1491: from ben_comp_lvl_fctr clf,
1492: ben_comp_lvl_rt_f clr,
1493: ben_vrbl_rt_prfl_f vpf,
1494: ben_bnft_vrbl_rt_f avr,
1495: ben_cvg_amt_calc_mthd_f abr
1496: where abr.oipl_id = p_oipl_id
1497: and abr.business_group_id = p_business_group_id
1498: and p_effective_date

Line 1687: ben_bnft_vrbl_rt_f avr,

1683: clf.comp_calc_rl
1684: from ben_comp_lvl_fctr clf,
1685: ben_comp_lvl_rt_f clr,
1686: ben_vrbl_rt_prfl_f vpf,
1687: ben_bnft_vrbl_rt_f avr,
1688: ben_cvg_amt_calc_mthd_f abr
1689: where abr.plip_id = p_plip_id
1690: and abr.business_group_id = p_business_group_id
1691: and p_effective_date

Line 1922: ben_bnft_vrbl_rt_f avr,

1918: cla.cmbnd_max_val
1919: from ben_cmbn_age_los_fctr cla,
1920: ben_cmbn_age_los_rt_f cmr,
1921: ben_vrbl_rt_prfl_f vpf,
1922: ben_bnft_vrbl_rt_f avr,
1923: ben_cvg_amt_calc_mthd_f abr
1924: where abr.pl_id = p_pl_id
1925: and abr.business_group_id = p_business_group_id
1926: and p_effective_date

Line 2106: ben_bnft_vrbl_rt_f avr,

2102: cla.cmbnd_max_val
2103: from ben_cmbn_age_los_fctr cla,
2104: ben_cmbn_age_los_rt_f cmr,
2105: ben_vrbl_rt_prfl_f vpf,
2106: ben_bnft_vrbl_rt_f avr,
2107: ben_cvg_amt_calc_mthd_f abr
2108: where abr.oipl_id = p_oipl_id
2109: and abr.business_group_id = p_business_group_id
2110: and p_effective_date

Line 2290: ben_bnft_vrbl_rt_f avr,

2286: cla.cmbnd_max_val
2287: from ben_cmbn_age_los_fctr cla,
2288: ben_cmbn_age_los_rt_f cmr,
2289: ben_vrbl_rt_prfl_f vpf,
2290: ben_bnft_vrbl_rt_f avr,
2291: ben_cvg_amt_calc_mthd_f abr
2292: where abr.plip_id = p_plip_id
2293: and abr.business_group_id = p_business_group_id
2294: and p_effective_date

Line 2527: ben_bnft_vrbl_rt_f avr,

2523: pff.mx_pct_val
2524: from ben_pct_fl_tm_fctr pff,
2525: ben_pct_fl_tm_rt_f pfr,
2526: ben_vrbl_rt_prfl_f vpf,
2527: ben_bnft_vrbl_rt_f avr,
2528: ben_cvg_amt_calc_mthd_f abr
2529: where abr.pl_id = p_pl_id
2530: and abr.business_group_id = p_business_group_id
2531: and p_effective_date

Line 2701: ben_bnft_vrbl_rt_f avr,

2697: pff.mx_pct_val
2698: from ben_pct_fl_tm_fctr pff,
2699: ben_pct_fl_tm_rt_f pfr,
2700: ben_vrbl_rt_prfl_f vpf,
2701: ben_bnft_vrbl_rt_f avr,
2702: ben_cvg_amt_calc_mthd_f abr
2703: where abr.oipl_id = p_oipl_id
2704: and abr.business_group_id = p_business_group_id
2705: and p_effective_date

Line 2875: ben_bnft_vrbl_rt_f avr,

2871: pff.mx_pct_val
2872: from ben_pct_fl_tm_fctr pff,
2873: ben_pct_fl_tm_rt_f pfr,
2874: ben_vrbl_rt_prfl_f vpf,
2875: ben_bnft_vrbl_rt_f avr,
2876: ben_cvg_amt_calc_mthd_f abr
2877: where abr.plip_id = p_plip_id
2878: and abr.business_group_id = p_business_group_id
2879: and p_effective_date

Line 3105: ben_bnft_vrbl_rt_f avr,

3101: hwf.hrs_wkd_calc_rl
3102: from ben_hrs_wkd_in_perd_fctr hwf,
3103: ben_hrs_wkd_in_perd_rt_f hwr,
3104: ben_vrbl_rt_prfl_f vpf,
3105: ben_bnft_vrbl_rt_f avr,
3106: ben_cvg_amt_calc_mthd_f abr
3107: where abr.pl_id = p_pl_id
3108: and abr.business_group_id = p_business_group_id
3109: and p_effective_date

Line 3296: ben_bnft_vrbl_rt_f avr,

3292: hwf.hrs_wkd_calc_rl
3293: from ben_hrs_wkd_in_perd_fctr hwf,
3294: ben_hrs_wkd_in_perd_rt_f hwr,
3295: ben_vrbl_rt_prfl_f vpf,
3296: ben_bnft_vrbl_rt_f avr,
3297: ben_cvg_amt_calc_mthd_f abr
3298: where abr.oipl_id = p_oipl_id
3299: and abr.business_group_id = p_business_group_id
3300: and p_effective_date

Line 3487: ben_bnft_vrbl_rt_f avr,

3483: hwf.hrs_wkd_calc_rl
3484: from ben_hrs_wkd_in_perd_fctr hwf,
3485: ben_hrs_wkd_in_perd_rt_f hwr,
3486: ben_vrbl_rt_prfl_f vpf,
3487: ben_bnft_vrbl_rt_f avr,
3488: ben_cvg_amt_calc_mthd_f abr
3489: where abr.plip_id = p_plip_id
3490: and abr.business_group_id = p_business_group_id
3491: and p_effective_date