[Home] [Help]
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
70: between apr.effective_start_date
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
258: between apr.effective_start_date
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
488: between apr.effective_start_date
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
677: between apr.effective_start_date
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
911: between apr.effective_start_date
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
1115: between apr.effective_start_date
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
1351: between apr.effective_start_date
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
1546: between apr.effective_start_date
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
1784: between apr.effective_start_date
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
1958: between apr.effective_start_date
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
2178: between apr.effective_start_date
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
2380: between apr.effective_start_date