[Home] [Help]
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
68: between abr.effective_start_date
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
257: between abr.effective_start_date
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
449: between abr.effective_start_date
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
689: between abr.effective_start_date
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
878: between abr.effective_start_date
1055: agf.rndg_rl,
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
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
1306: between abr.effective_start_date
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
1499: between abr.effective_start_date
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
1692: between abr.effective_start_date
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
1927: between abr.effective_start_date
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
2111: between abr.effective_start_date
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
2295: between abr.effective_start_date
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
2532: between abr.effective_start_date
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
2706: between abr.effective_start_date
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
2880: between abr.effective_start_date
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
3110: between abr.effective_start_date
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
3301: between abr.effective_start_date
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
3492: between abr.effective_start_date