APPS.BEN_DERIVE_PART_AND_RATE_PREM dependencies on BEN_ACTL_PREM_VRBL_RT_F

Line 65: ben_actl_prem_vrbl_rt_f apv,

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

Line 253: ben_actl_prem_vrbl_rt_f apv,

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

Line 483: ben_actl_prem_vrbl_rt_f apv,

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

Line 672: ben_actl_prem_vrbl_rt_f apv,

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

Line 906: ben_actl_prem_vrbl_rt_f apv,

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

Line 1110: ben_actl_prem_vrbl_rt_f apv,

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

Line 1346: ben_actl_prem_vrbl_rt_f apv,

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

Line 1541: ben_actl_prem_vrbl_rt_f apv,

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

Line 1779: ben_actl_prem_vrbl_rt_f apv,

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

Line 1953: ben_actl_prem_vrbl_rt_f apv,

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

Line 2173: ben_actl_prem_vrbl_rt_f apv,

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

Line 2375: ben_actl_prem_vrbl_rt_f apv,

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