APPS.BEN_DERIVE_PART_AND_RATE_CVG dependencies on BEN_VRBL_RT_PRFL_F

Line 62: ben_vrbl_rt_prfl_f vpf,

58: lsf.mn_los_num,
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

Line 251: ben_vrbl_rt_prfl_f vpf,

247: lsf.mn_los_num,
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

Line 443: ben_vrbl_rt_prfl_f vpf,

439: lsf.mn_los_num,
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

Line 683: ben_vrbl_rt_prfl_f vpf,

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

Line 872: ben_vrbl_rt_prfl_f vpf,

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

Line 1061: ben_vrbl_rt_prfl_f vpf,

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
1065: and p_effective_date

Line 1300: ben_vrbl_rt_prfl_f vpf,

1296: clf.comp_lvl_fctr_id,
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

Line 1493: ben_vrbl_rt_prfl_f vpf,

1489: clf.comp_lvl_fctr_id,
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

Line 1686: ben_vrbl_rt_prfl_f vpf,

1682: clf.comp_lvl_fctr_id,
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

Line 1921: ben_vrbl_rt_prfl_f vpf,

1917: cla.cmbnd_min_val,
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

Line 2105: ben_vrbl_rt_prfl_f vpf,

2101: cla.cmbnd_min_val,
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

Line 2289: ben_vrbl_rt_prfl_f vpf,

2285: cla.cmbnd_min_val,
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

Line 2526: ben_vrbl_rt_prfl_f vpf,

2522: pff.mn_pct_val,
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

Line 2700: ben_vrbl_rt_prfl_f vpf,

2696: pff.mn_pct_val,
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

Line 2874: ben_vrbl_rt_prfl_f vpf,

2870: pff.mn_pct_val,
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

Line 3104: ben_vrbl_rt_prfl_f vpf,

3100: hwf.once_r_cntug_cd,
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

Line 3295: ben_vrbl_rt_prfl_f vpf,

3291: hwf.once_r_cntug_cd,
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

Line 3486: ben_vrbl_rt_prfl_f vpf,

3482: hwf.once_r_cntug_cd,
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