APPS.BEN_DERIVE_PART_AND_RATE_PREM dependencies on BEN_VRBL_RT_PRFL_F

Line 64: ben_vrbl_rt_prfl_f vpf,

60: lsf.mn_los_num,
61: lsf.mx_los_num
62: from ben_los_fctr lsf,
63: ben_los_rt_f lsr,
64: ben_vrbl_rt_prfl_f vpf,
65: ben_actl_prem_vrbl_rt_f apv,
66: ben_actl_prem_f apr
67: where apr.pl_id = p_pl_id
68: and apr.business_group_id = p_business_group_id

Line 252: ben_vrbl_rt_prfl_f vpf,

248: lsf.mn_los_num,
249: lsf.mx_los_num
250: from ben_los_fctr lsf,
251: ben_los_rt_f lsr,
252: ben_vrbl_rt_prfl_f vpf,
253: ben_actl_prem_vrbl_rt_f apv,
254: ben_actl_prem_f apr
255: where apr.oipl_id = p_oipl_id
256: and apr.business_group_id = p_business_group_id

Line 482: ben_vrbl_rt_prfl_f vpf,

478: agf.mn_age_num,
479: agf.mx_age_num
480: from ben_age_fctr agf,
481: ben_age_rt_f art,
482: ben_vrbl_rt_prfl_f vpf,
483: ben_actl_prem_vrbl_rt_f apv,
484: ben_actl_prem_f apr
485: where apr.pl_id = p_pl_id
486: and apr.business_group_id = p_business_group_id

Line 671: ben_vrbl_rt_prfl_f vpf,

667: agf.mn_age_num,
668: agf.mx_age_num
669: from ben_age_fctr agf,
670: ben_age_rt_f art,
671: ben_vrbl_rt_prfl_f vpf,
672: ben_actl_prem_vrbl_rt_f apv,
673: ben_actl_prem_f apr
674: where apr.oipl_id = p_oipl_id
675: and apr.business_group_id = p_business_group_id

Line 905: ben_vrbl_rt_prfl_f vpf,

901: clf.comp_lvl_fctr_id,
902: clf.comp_calc_rl
903: from ben_comp_lvl_fctr clf,
904: ben_comp_lvl_rt_f clr,
905: ben_vrbl_rt_prfl_f vpf,
906: ben_actl_prem_vrbl_rt_f apv,
907: ben_actl_prem_f apr
908: where apr.pl_id = p_pl_id
909: and apr.business_group_id = p_business_group_id

Line 1109: ben_vrbl_rt_prfl_f vpf,

1105: clf.comp_lvl_fctr_id,
1106: clf.comp_calc_rl
1107: from ben_comp_lvl_fctr clf,
1108: ben_comp_lvl_rt_f clr,
1109: ben_vrbl_rt_prfl_f vpf,
1110: ben_actl_prem_vrbl_rt_f apv,
1111: ben_actl_prem_f apr
1112: where apr.oipl_id = p_oipl_id
1113: and apr.business_group_id = p_business_group_id

Line 1345: ben_vrbl_rt_prfl_f vpf,

1341: cla.cmbnd_min_val,
1342: cla.cmbnd_max_val
1343: from ben_cmbn_age_los_fctr cla,
1344: ben_cmbn_age_los_rt_f cmr,
1345: ben_vrbl_rt_prfl_f vpf,
1346: ben_actl_prem_vrbl_rt_f apv,
1347: ben_actl_prem_f apr
1348: where apr.pl_id = p_pl_id
1349: and apr.business_group_id = p_business_group_id

Line 1540: ben_vrbl_rt_prfl_f vpf,

1536: cla.cmbnd_min_val,
1537: cla.cmbnd_max_val
1538: from ben_cmbn_age_los_fctr cla,
1539: ben_cmbn_age_los_rt_f cmr,
1540: ben_vrbl_rt_prfl_f vpf,
1541: ben_actl_prem_vrbl_rt_f apv,
1542: ben_actl_prem_f apr
1543: where apr.oipl_id = p_oipl_id
1544: and apr.business_group_id = p_business_group_id

Line 1778: ben_vrbl_rt_prfl_f vpf,

1774: pff.mn_pct_val,
1775: pff.mx_pct_val
1776: from ben_pct_fl_tm_fctr pff,
1777: ben_pct_fl_tm_rt_f pfr,
1778: ben_vrbl_rt_prfl_f vpf,
1779: ben_actl_prem_vrbl_rt_f apv,
1780: ben_actl_prem_f apr
1781: where apr.pl_id = p_pl_id
1782: and apr.business_group_id = p_business_group_id

Line 1952: ben_vrbl_rt_prfl_f vpf,

1948: pff.mn_pct_val,
1949: pff.mx_pct_val
1950: from ben_pct_fl_tm_fctr pff,
1951: ben_pct_fl_tm_rt_f pfr,
1952: ben_vrbl_rt_prfl_f vpf,
1953: ben_actl_prem_vrbl_rt_f apv,
1954: ben_actl_prem_f apr
1955: where apr.oipl_id = p_oipl_id
1956: and apr.business_group_id = p_business_group_id

Line 2172: ben_vrbl_rt_prfl_f vpf,

2168: hwf.once_r_cntug_cd,
2169: hwf.hrs_wkd_calc_rl
2170: from ben_hrs_wkd_in_perd_fctr hwf,
2171: ben_hrs_wkd_in_perd_rt_f hwr,
2172: ben_vrbl_rt_prfl_f vpf,
2173: ben_actl_prem_vrbl_rt_f apv,
2174: ben_actl_prem_f apr
2175: where apr.pl_id = p_pl_id
2176: and apr.business_group_id = p_business_group_id

Line 2374: ben_vrbl_rt_prfl_f vpf,

2370: hwf.once_r_cntug_cd,
2371: hwf.hrs_wkd_calc_rl
2372: from ben_hrs_wkd_in_perd_fctr hwf,
2373: ben_hrs_wkd_in_perd_rt_f hwr,
2374: ben_vrbl_rt_prfl_f vpf,
2375: ben_actl_prem_vrbl_rt_f apv,
2376: ben_actl_prem_f apr
2377: where apr.oipl_id = p_oipl_id
2378: and apr.business_group_id = p_business_group_id