[Home] [Help]
1306: FROM ben_los_fctr lsf
1307: ,ben_los_rt_f lsr
1308: ,ben_vrbl_rt_prfl_f vpf
1309: ,ben_acty_vrbl_rt_f avr
1310: ,ben_acty_base_rt_f abr
1311: WHERE abr.pgm_id = p_pgm_id
1312: AND p_effective_date BETWEEN abr.effective_start_date
1313: AND abr.effective_end_date
1314: AND abr.acty_base_rt_id = avr.acty_base_rt_id
1380: ,ben_vrbl_rt_elig_prfl_f vep
1381: --NEW
1382: ,ben_vrbl_rt_prfl_f vpf
1383: ,ben_acty_vrbl_rt_f avr
1384: ,ben_acty_base_rt_f abr
1385: WHERE abr.pgm_id = p_pgm_id
1386: AND p_effective_date BETWEEN abr.effective_start_date
1387: AND abr.effective_end_date
1388: AND abr.acty_base_rt_id = avr.acty_base_rt_id
1601: FROM ben_los_fctr lsf
1602: ,ben_los_rt_f lsr
1603: ,ben_vrbl_rt_prfl_f vpf
1604: ,ben_acty_vrbl_rt_f avr
1605: ,ben_acty_base_rt_f abr
1606: WHERE abr.pl_id = p_pl_id
1607: AND p_effective_date BETWEEN abr.effective_start_date
1608: AND abr.effective_end_date
1609: AND abr.acty_base_rt_id = avr.acty_base_rt_id
1679: ,ben_vrbl_rt_elig_prfl_f vep
1680: --
1681: ,ben_vrbl_rt_prfl_f vpf
1682: ,ben_acty_vrbl_rt_f avr
1683: ,ben_acty_base_rt_f abr
1684: WHERE abr.pl_id = p_pl_id
1685: AND p_effective_date BETWEEN abr.effective_start_date
1686: AND abr.effective_end_date
1687: AND abr.acty_base_rt_id = avr.acty_base_rt_id
1904: FROM ben_los_fctr lsf
1905: ,ben_los_rt_f lsr
1906: ,ben_vrbl_rt_prfl_f vpf
1907: ,ben_acty_vrbl_rt_f avr
1908: ,ben_acty_base_rt_f abr
1909: WHERE ( abr.oipl_id = p_oipl_id
1910: --
1911: --START Option level Rates Enhancements
1912: or ( abr.opt_id = l_opt_id and
1909: WHERE ( abr.oipl_id = p_oipl_id
1910: --
1911: --START Option level Rates Enhancements
1912: or ( abr.opt_id = l_opt_id and
1913: not exists (select null from ben_acty_base_rt_f abr1
1914: where abr1.oipl_id = p_oipl_id )))
1915: --END Option level Rates Enhancements
1916: --
1917: AND p_effective_date BETWEEN abr.effective_start_date
1985: ,ben_eligy_prfl_f elp
1986: ,ben_vrbl_rt_elig_prfl_f vep
1987: ,ben_vrbl_rt_prfl_f vpf
1988: ,ben_acty_vrbl_rt_f avr
1989: ,ben_acty_base_rt_f abr
1990: WHERE ( abr.oipl_id = p_oipl_id
1991: --
1992: --START Option level Rates Enhancements
1993: or ( abr.opt_id = l_opt_id and
1990: WHERE ( abr.oipl_id = p_oipl_id
1991: --
1992: --START Option level Rates Enhancements
1993: or ( abr.opt_id = l_opt_id and
1994: not exists (select null from ben_acty_base_rt_f abr1
1995: where abr1.oipl_id = p_oipl_id )))
1996: --END Option level Rates Enhancements
1997: --
1998: AND p_effective_date BETWEEN abr.effective_start_date
2219: FROM ben_los_fctr lsf
2220: ,ben_los_rt_f lsr
2221: ,ben_vrbl_rt_prfl_f vpf
2222: ,ben_acty_vrbl_rt_f avr
2223: ,ben_acty_base_rt_f abr
2224: WHERE abr.plip_id = p_plip_id
2225: AND p_effective_date BETWEEN abr.effective_start_date
2226: AND abr.effective_end_date
2227: AND abr.acty_base_rt_id = avr.acty_base_rt_id
2293: ,ben_eligy_prfl_f elp
2294: ,ben_vrbl_rt_elig_prfl_f vep
2295: ,ben_vrbl_rt_prfl_f vpf
2296: ,ben_acty_vrbl_rt_f avr
2297: ,ben_acty_base_rt_f abr
2298: WHERE abr.plip_id = p_plip_id
2299: AND p_effective_date BETWEEN abr.effective_start_date
2300: AND abr.effective_end_date
2301: AND abr.acty_base_rt_id = avr.acty_base_rt_id
2518: FROM ben_los_fctr lsf
2519: ,ben_los_rt_f lsr
2520: ,ben_vrbl_rt_prfl_f vpf
2521: ,ben_acty_vrbl_rt_f avr
2522: ,ben_acty_base_rt_f abr
2523: WHERE abr.ptip_id = p_ptip_id
2524: AND p_effective_date BETWEEN abr.effective_start_date
2525: AND abr.effective_end_date
2526: AND abr.acty_base_rt_id = avr.acty_base_rt_id
2592: ,ben_eligy_prfl_f elp
2593: ,ben_vrbl_rt_elig_prfl_f vep
2594: ,ben_vrbl_rt_prfl_f vpf
2595: ,ben_acty_vrbl_rt_f avr
2596: ,ben_acty_base_rt_f abr
2597: WHERE abr.ptip_id = p_ptip_id
2598: AND p_effective_date BETWEEN abr.effective_start_date
2599: AND abr.effective_end_date
2600: AND abr.acty_base_rt_id = avr.acty_base_rt_id
2817: FROM ben_los_fctr lsf
2818: ,ben_los_rt_f lsr
2819: ,ben_vrbl_rt_prfl_f vpf
2820: ,ben_acty_vrbl_rt_f avr
2821: ,ben_acty_base_rt_f abr
2822: WHERE abr.oiplip_id = p_oiplip_id
2823: AND p_effective_date BETWEEN abr.effective_start_date
2824: AND abr.effective_end_date
2825: AND abr.acty_base_rt_id = avr.acty_base_rt_id
2891: ,ben_eligy_prfl_f elp
2892: ,ben_vrbl_rt_elig_prfl_f vep
2893: ,ben_vrbl_rt_prfl_f vpf
2894: ,ben_acty_vrbl_rt_f avr
2895: ,ben_acty_base_rt_f abr
2896: WHERE abr.oiplip_id = p_oiplip_id
2897: AND p_effective_date BETWEEN abr.effective_start_date
2898: AND abr.effective_end_date
2899: AND abr.acty_base_rt_id = avr.acty_base_rt_id
4305: FROM ben_age_fctr agf
4306: ,ben_age_rt_f art
4307: ,ben_vrbl_rt_prfl_f vpf
4308: ,ben_acty_vrbl_rt_f avr
4309: ,ben_acty_base_rt_f abr
4310: WHERE abr.pgm_id = p_pgm_id
4311: AND p_effective_date BETWEEN abr.effective_start_date
4312: AND abr.effective_end_date
4313: AND abr.acty_base_rt_id = avr.acty_base_rt_id
4377: ,ben_eligy_prfl_f elp
4378: ,ben_vrbl_rt_elig_prfl_f vep
4379: ,ben_vrbl_rt_prfl_f vpf
4380: ,ben_acty_vrbl_rt_f avr
4381: ,ben_acty_base_rt_f abr
4382: WHERE abr.pgm_id = p_pgm_id
4383: AND p_effective_date BETWEEN abr.effective_start_date
4384: AND abr.effective_end_date
4385: AND abr.acty_base_rt_id = avr.acty_base_rt_id
4598: FROM ben_age_fctr agf
4599: ,ben_age_rt_f art
4600: ,ben_vrbl_rt_prfl_f vpf
4601: ,ben_acty_vrbl_rt_f avr
4602: ,ben_acty_base_rt_f abr
4603: WHERE abr.pl_id = p_pl_id
4604: AND p_effective_date BETWEEN abr.effective_start_date
4605: AND abr.effective_end_date
4606: AND abr.acty_base_rt_id = avr.acty_base_rt_id
4670: ,ben_eligy_prfl_f elp
4671: ,ben_vrbl_rt_elig_prfl_f vep
4672: ,ben_vrbl_rt_prfl_f vpf
4673: ,ben_acty_vrbl_rt_f avr
4674: ,ben_acty_base_rt_f abr
4675: WHERE abr.pl_id = p_pl_id
4676: AND p_effective_date BETWEEN abr.effective_start_date
4677: AND abr.effective_end_date
4678: AND abr.acty_base_rt_id = avr.acty_base_rt_id
4892: FROM ben_age_fctr agf
4893: ,ben_age_rt_f art
4894: ,ben_vrbl_rt_prfl_f vpf
4895: ,ben_acty_vrbl_rt_f avr
4896: ,ben_acty_base_rt_f abr
4897: WHERE ( abr.oipl_id = p_oipl_id
4898: --
4899: --START Option level Rates Enhancements
4900: or ( abr.opt_id = l_opt_id and
4897: WHERE ( abr.oipl_id = p_oipl_id
4898: --
4899: --START Option level Rates Enhancements
4900: or ( abr.opt_id = l_opt_id and
4901: not exists (select null from ben_acty_base_rt_f abr1
4902: where abr1.oipl_id = p_oipl_id )))
4903: --END Option level Rates Enhancements
4904: --
4905: AND p_effective_date BETWEEN abr.effective_start_date
4971: ,ben_eligy_prfl_f elp
4972: ,ben_vrbl_rt_elig_prfl_f vep
4973: ,ben_vrbl_rt_prfl_f vpf
4974: ,ben_acty_vrbl_rt_f avr
4975: ,ben_acty_base_rt_f abr
4976: WHERE ( abr.oipl_id = p_oipl_id
4977: --
4978: --START Option level Rates Enhancements
4979: or ( abr.opt_id = l_opt_id and
4976: WHERE ( abr.oipl_id = p_oipl_id
4977: --
4978: --START Option level Rates Enhancements
4979: or ( abr.opt_id = l_opt_id and
4980: not exists (select null from ben_acty_base_rt_f abr1
4981: where abr1.oipl_id = p_oipl_id )))
4982: --END Option level Rates Enhancements
4983: --
4984: AND p_effective_date BETWEEN abr.effective_start_date
5197: ,agf.rndg_rl
5198: ,agf.age_calc_rl
5199: ,agf.mn_age_num
5200: ,agf.mx_age_num
5201: FROM ben_acty_base_rt_f abr
5202: ,ben_acty_vrbl_rt_f avr
5203: ,ben_vrbl_rt_prfl_f vpf
5204: ,ben_age_rt_f art
5205: ,ben_age_fctr agf
5267: ,agf.rndg_rl
5268: ,agf.age_calc_rl
5269: ,agf.mn_age_num
5270: ,agf.mx_age_num
5271: FROM ben_acty_base_rt_f abr
5272: ,ben_acty_vrbl_rt_f avr
5273: ,ben_eligy_prfl_f elp
5274: ,ben_vrbl_rt_elig_prfl_f vep
5275: ,ben_vrbl_rt_prfl_f vpf
5492: ,agf.rndg_rl
5493: ,agf.age_calc_rl
5494: ,agf.mn_age_num
5495: ,agf.mx_age_num
5496: FROM ben_acty_base_rt_f abr
5497: ,ben_acty_vrbl_rt_f avr
5498: ,ben_vrbl_rt_prfl_f vpf
5499: ,ben_age_rt_f art
5500: ,ben_age_fctr agf
5561: ,agf.rndg_rl
5562: ,agf.age_calc_rl
5563: ,agf.mn_age_num
5564: ,agf.mx_age_num
5565: FROM ben_acty_base_rt_f abr
5566: ,ben_acty_vrbl_rt_f avr
5567: ,ben_eligy_prfl_f elp
5568: ,ben_vrbl_rt_elig_prfl_f vep
5569: ,ben_vrbl_rt_prfl_f vpf
5785: ,agf.rndg_rl
5786: ,agf.age_calc_rl
5787: ,agf.mn_age_num
5788: ,agf.mx_age_num
5789: FROM ben_acty_base_rt_f abr
5790: ,ben_acty_vrbl_rt_f avr
5791: ,ben_vrbl_rt_prfl_f vpf
5792: ,ben_age_rt_f art
5793: ,ben_age_fctr agf
5854: ,agf.rndg_rl
5855: ,agf.age_calc_rl
5856: ,agf.mn_age_num
5857: ,agf.mx_age_num
5858: FROM ben_acty_base_rt_f abr
5859: ,ben_acty_vrbl_rt_f avr
5860: ,ben_eligy_prfl_f elp
5861: ,ben_vrbl_rt_elig_prfl_f vep
5862: ,ben_vrbl_rt_prfl_f vpf
7179: FROM ben_comp_lvl_fctr clf
7180: ,ben_comp_lvl_rt_f clr
7181: ,ben_vrbl_rt_prfl_f vpf
7182: ,ben_acty_vrbl_rt_f avr
7183: ,ben_acty_base_rt_f abr
7184: WHERE abr.pgm_id = p_pgm_id
7185: AND p_effective_date BETWEEN abr.effective_start_date
7186: AND abr.effective_end_date
7187: AND abr.acty_base_rt_id = avr.acty_base_rt_id
7255: ,ben_eligy_prfl_f elp
7256: ,ben_vrbl_rt_elig_prfl_f vep
7257: ,ben_vrbl_rt_prfl_f vpf
7258: ,ben_acty_vrbl_rt_f avr
7259: ,ben_acty_base_rt_f abr
7260: WHERE abr.pgm_id = p_pgm_id
7261: AND p_effective_date BETWEEN abr.effective_start_date
7262: AND abr.effective_end_date
7263: AND abr.acty_base_rt_id = avr.acty_base_rt_id
7480: FROM ben_comp_lvl_fctr clf
7481: ,ben_comp_lvl_rt_f clr
7482: ,ben_vrbl_rt_prfl_f vpf
7483: ,ben_acty_vrbl_rt_f avr
7484: ,ben_acty_base_rt_f abr
7485: WHERE abr.pl_id = p_pl_id
7486: AND p_effective_date BETWEEN abr.effective_start_date
7487: AND abr.effective_end_date
7488: AND abr.acty_base_rt_id = avr.acty_base_rt_id
7556: ,ben_eligy_prfl_f elp
7557: ,ben_vrbl_rt_elig_prfl_f vep
7558: ,ben_vrbl_rt_prfl_f vpf
7559: ,ben_acty_vrbl_rt_f avr
7560: ,ben_acty_base_rt_f abr
7561: WHERE abr.pl_id = p_pl_id
7562: AND p_effective_date BETWEEN abr.effective_start_date
7563: AND abr.effective_end_date
7564: AND abr.acty_base_rt_id = avr.acty_base_rt_id
7783: FROM ben_comp_lvl_fctr clf
7784: ,ben_comp_lvl_rt_f clr
7785: ,ben_vrbl_rt_prfl_f vpf
7786: ,ben_acty_vrbl_rt_f avr
7787: ,ben_acty_base_rt_f abr
7788: WHERE ( abr.oipl_id = p_oipl_id
7789: --
7790: --START Option level Rates Enhancements
7791: or ( abr.opt_id = l_opt_id and
7788: WHERE ( abr.oipl_id = p_oipl_id
7789: --
7790: --START Option level Rates Enhancements
7791: or ( abr.opt_id = l_opt_id and
7792: not exists (select null from ben_acty_base_rt_f abr1
7793: where abr1.oipl_id = p_oipl_id )))
7794: --END Option level Rates Enhancements
7795: --
7796: AND p_effective_date BETWEEN abr.effective_start_date
7866: ,ben_eligy_prfl_f elp
7867: ,ben_vrbl_rt_elig_prfl_f vep
7868: ,ben_vrbl_rt_prfl_f vpf
7869: ,ben_acty_vrbl_rt_f avr
7870: ,ben_acty_base_rt_f abr
7871: WHERE ( abr.oipl_id = p_oipl_id
7872: --
7873: --START Option level Rates Enhancements
7874: or ( abr.opt_id = l_opt_id and
7871: WHERE ( abr.oipl_id = p_oipl_id
7872: --
7873: --START Option level Rates Enhancements
7874: or ( abr.opt_id = l_opt_id and
7875: not exists (select null from ben_acty_base_rt_f abr1
7876: where abr1.oipl_id = p_oipl_id )))
7877: --END Option level Rates Enhancements
7878: --
7879: AND p_effective_date BETWEEN abr.effective_start_date
8100: FROM ben_comp_lvl_fctr clf
8101: ,ben_comp_lvl_rt_f clr
8102: ,ben_vrbl_rt_prfl_f vpf
8103: ,ben_acty_vrbl_rt_f avr
8104: ,ben_acty_base_rt_f abr
8105: WHERE abr.plip_id = p_plip_id
8106: AND p_effective_date BETWEEN abr.effective_start_date
8107: AND abr.effective_end_date
8108: AND abr.acty_base_rt_id = avr.acty_base_rt_id
8176: ,ben_eligy_prfl_f elp
8177: ,ben_vrbl_rt_elig_prfl_f vep
8178: ,ben_vrbl_rt_prfl_f vpf
8179: ,ben_acty_vrbl_rt_f avr
8180: ,ben_acty_base_rt_f abr
8181: WHERE abr.plip_id = p_plip_id
8182: AND p_effective_date BETWEEN abr.effective_start_date
8183: AND abr.effective_end_date
8184: AND abr.acty_base_rt_id = avr.acty_base_rt_id
8401: FROM ben_comp_lvl_fctr clf
8402: ,ben_comp_lvl_rt_f clr
8403: ,ben_vrbl_rt_prfl_f vpf
8404: ,ben_acty_vrbl_rt_f avr
8405: ,ben_acty_base_rt_f abr
8406: WHERE abr.ptip_id = p_ptip_id
8407: AND p_effective_date BETWEEN abr.effective_start_date
8408: AND abr.effective_end_date
8409: AND abr.acty_base_rt_id = avr.acty_base_rt_id
8477: ,ben_eligy_prfl_f elp
8478: ,ben_vrbl_rt_elig_prfl_f vep
8479: ,ben_vrbl_rt_prfl_f vpf
8480: ,ben_acty_vrbl_rt_f avr
8481: ,ben_acty_base_rt_f abr
8482: WHERE abr.ptip_id = p_ptip_id
8483: AND p_effective_date BETWEEN abr.effective_start_date
8484: AND abr.effective_end_date
8485: AND abr.acty_base_rt_id = avr.acty_base_rt_id
8702: FROM ben_comp_lvl_fctr clf
8703: ,ben_comp_lvl_rt_f clr
8704: ,ben_vrbl_rt_prfl_f vpf
8705: ,ben_acty_vrbl_rt_f avr
8706: ,ben_acty_base_rt_f abr
8707: WHERE abr.oiplip_id = p_oiplip_id
8708: AND p_effective_date BETWEEN abr.effective_start_date
8709: AND abr.effective_end_date
8710: AND abr.acty_base_rt_id = avr.acty_base_rt_id
8778: ,ben_eligy_prfl_f elp
8779: ,ben_vrbl_rt_elig_prfl_f vep
8780: ,ben_vrbl_rt_prfl_f vpf
8781: ,ben_acty_vrbl_rt_f avr
8782: ,ben_acty_base_rt_f abr
8783: WHERE abr.oiplip_id = p_oiplip_id
8784: AND p_effective_date BETWEEN abr.effective_start_date
8785: AND abr.effective_end_date
8786: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10046: FROM ben_cmbn_age_los_fctr cla
10047: ,ben_cmbn_age_los_rt_f cmr
10048: ,ben_vrbl_rt_prfl_f vpf
10049: ,ben_acty_vrbl_rt_f avr
10050: ,ben_acty_base_rt_f abr
10051: WHERE abr.pgm_id = p_pgm_id
10052: AND p_effective_date BETWEEN abr.effective_start_date
10053: AND abr.effective_end_date
10054: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10113: ,ben_eligy_prfl_f elp
10114: ,ben_vrbl_rt_elig_prfl_f vep
10115: ,ben_vrbl_rt_prfl_f vpf
10116: ,ben_acty_vrbl_rt_f avr
10117: ,ben_acty_base_rt_f abr
10118: WHERE abr.pgm_id = p_pgm_id
10119: AND p_effective_date BETWEEN abr.effective_start_date
10120: AND abr.effective_end_date
10121: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10329: FROM ben_cmbn_age_los_fctr cla
10330: ,ben_cmbn_age_los_rt_f cmr
10331: ,ben_vrbl_rt_prfl_f vpf
10332: ,ben_acty_vrbl_rt_f avr
10333: ,ben_acty_base_rt_f abr
10334: WHERE abr.pl_id = p_pl_id
10335: AND p_effective_date BETWEEN abr.effective_start_date
10336: AND abr.effective_end_date
10337: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10396: ,ben_eligy_prfl_f elp
10397: ,ben_vrbl_rt_elig_prfl_f vep
10398: ,ben_vrbl_rt_prfl_f vpf
10399: ,ben_acty_vrbl_rt_f avr
10400: ,ben_acty_base_rt_f abr
10401: WHERE abr.pl_id = p_pl_id
10402: AND p_effective_date BETWEEN abr.effective_start_date
10403: AND abr.effective_end_date
10404: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10614: FROM ben_cmbn_age_los_fctr cla
10615: ,ben_cmbn_age_los_rt_f cmr
10616: ,ben_vrbl_rt_prfl_f vpf
10617: ,ben_acty_vrbl_rt_f avr
10618: ,ben_acty_base_rt_f abr
10619: WHERE ( abr.oipl_id = p_oipl_id
10620: --
10621: --START Option level Rates Enhancements
10622: or ( abr.opt_id = l_opt_id and
10619: WHERE ( abr.oipl_id = p_oipl_id
10620: --
10621: --START Option level Rates Enhancements
10622: or ( abr.opt_id = l_opt_id and
10623: not exists (select null from ben_acty_base_rt_f abr1
10624: where abr1.oipl_id = p_oipl_id )))
10625: --END Option level Rates Enhancements
10626: --
10627: AND p_effective_date BETWEEN abr.effective_start_date
10688: ,ben_eligy_prfl_f elp
10689: ,ben_vrbl_rt_elig_prfl_f vep
10690: ,ben_vrbl_rt_prfl_f vpf
10691: ,ben_acty_vrbl_rt_f avr
10692: ,ben_acty_base_rt_f abr
10693: WHERE ( abr.oipl_id = p_oipl_id
10694: --
10695: --START Option level Rates Enhancements
10696: or ( abr.opt_id = l_opt_id and
10693: WHERE ( abr.oipl_id = p_oipl_id
10694: --
10695: --START Option level Rates Enhancements
10696: or ( abr.opt_id = l_opt_id and
10697: not exists (select null from ben_acty_base_rt_f abr1
10698: where abr1.oipl_id = p_oipl_id )))
10699: --END Option level Rates Enhancements
10700: --
10701: AND p_effective_date BETWEEN abr.effective_start_date
10913: FROM ben_cmbn_age_los_fctr cla
10914: ,ben_cmbn_age_los_rt_f cmr
10915: ,ben_vrbl_rt_prfl_f vpf
10916: ,ben_acty_vrbl_rt_f avr
10917: ,ben_acty_base_rt_f abr
10918: WHERE abr.plip_id = p_plip_id
10919: AND p_effective_date BETWEEN abr.effective_start_date
10920: AND abr.effective_end_date
10921: AND abr.acty_base_rt_id = avr.acty_base_rt_id
10980: ,ben_eligy_prfl_f elp
10981: ,ben_vrbl_rt_elig_prfl_f vep
10982: ,ben_vrbl_rt_prfl_f vpf
10983: ,ben_acty_vrbl_rt_f avr
10984: ,ben_acty_base_rt_f abr
10985: WHERE abr.plip_id = p_plip_id
10986: AND p_effective_date BETWEEN abr.effective_start_date
10987: AND abr.effective_end_date
10988: AND abr.acty_base_rt_id = avr.acty_base_rt_id
11195: FROM ben_cmbn_age_los_fctr cla
11196: ,ben_cmbn_age_los_rt_f cmr
11197: ,ben_vrbl_rt_prfl_f vpf
11198: ,ben_acty_vrbl_rt_f avr
11199: ,ben_acty_base_rt_f abr
11200: WHERE abr.ptip_id = p_ptip_id
11201: AND p_effective_date BETWEEN abr.effective_start_date
11202: AND abr.effective_end_date
11203: AND abr.acty_base_rt_id = avr.acty_base_rt_id
11262: ,ben_eligy_prfl_f elp
11263: ,ben_vrbl_rt_elig_prfl_f vep
11264: ,ben_vrbl_rt_prfl_f vpf
11265: ,ben_acty_vrbl_rt_f avr
11266: ,ben_acty_base_rt_f abr
11267: WHERE abr.ptip_id = p_ptip_id
11268: AND p_effective_date BETWEEN abr.effective_start_date
11269: AND abr.effective_end_date
11270: AND abr.acty_base_rt_id = avr.acty_base_rt_id
11478: FROM ben_cmbn_age_los_fctr cla
11479: ,ben_cmbn_age_los_rt_f cmr
11480: ,ben_vrbl_rt_prfl_f vpf
11481: ,ben_acty_vrbl_rt_f avr
11482: ,ben_acty_base_rt_f abr
11483: WHERE abr.oiplip_id = p_oiplip_id
11484: AND p_effective_date BETWEEN abr.effective_start_date
11485: AND abr.effective_end_date
11486: AND abr.acty_base_rt_id = avr.acty_base_rt_id
11545: ,ben_eligy_prfl_f elp
11546: ,ben_vrbl_rt_elig_prfl_f vep
11547: ,ben_vrbl_rt_prfl_f vpf
11548: ,ben_acty_vrbl_rt_f avr
11549: ,ben_acty_base_rt_f abr
11550: WHERE abr.oiplip_id = p_oiplip_id
11551: AND p_effective_date BETWEEN abr.effective_start_date
11552: AND abr.effective_end_date
11553: AND abr.acty_base_rt_id = avr.acty_base_rt_id
12826: FROM ben_pct_fl_tm_fctr pff
12827: ,ben_pct_fl_tm_rt_f pfr
12828: ,ben_vrbl_rt_prfl_f vpf
12829: ,ben_acty_vrbl_rt_f avr
12830: ,ben_acty_base_rt_f abr
12831: WHERE abr.pgm_id = p_pgm_id
12832: AND p_effective_date BETWEEN abr.effective_start_date
12833: AND abr.effective_end_date
12834: AND abr.acty_base_rt_id = avr.acty_base_rt_id
12880: ,ben_eligy_prfl_f elp
12881: ,ben_vrbl_rt_elig_prfl_f vep
12882: ,ben_vrbl_rt_prfl_f vpf
12883: ,ben_acty_vrbl_rt_f avr
12884: ,ben_acty_base_rt_f abr
12885: WHERE abr.pgm_id = p_pgm_id
12886: AND p_effective_date BETWEEN abr.effective_start_date
12887: AND abr.effective_end_date
12888: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13083: FROM ben_pct_fl_tm_fctr pff
13084: ,ben_pct_fl_tm_rt_f pfr
13085: ,ben_vrbl_rt_prfl_f vpf
13086: ,ben_acty_vrbl_rt_f avr
13087: ,ben_acty_base_rt_f abr
13088: WHERE abr.pl_id = p_pl_id
13089: AND p_effective_date BETWEEN abr.effective_start_date
13090: AND abr.effective_end_date
13091: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13137: ,ben_eligy_prfl_f elp
13138: ,ben_vrbl_rt_elig_prfl_f vep
13139: ,ben_vrbl_rt_prfl_f vpf
13140: ,ben_acty_vrbl_rt_f avr
13141: ,ben_acty_base_rt_f abr
13142: WHERE abr.pl_id = p_pl_id
13143: AND p_effective_date BETWEEN abr.effective_start_date
13144: AND abr.effective_end_date
13145: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13342: FROM ben_pct_fl_tm_fctr pff
13343: ,ben_pct_fl_tm_rt_f pfr
13344: ,ben_vrbl_rt_prfl_f vpf
13345: ,ben_acty_vrbl_rt_f avr
13346: ,ben_acty_base_rt_f abr
13347: WHERE ( abr.oipl_id = p_oipl_id
13348: --
13349: --START Option level Rates Enhancements
13350: or ( abr.opt_id = l_opt_id and
13347: WHERE ( abr.oipl_id = p_oipl_id
13348: --
13349: --START Option level Rates Enhancements
13350: or ( abr.opt_id = l_opt_id and
13351: not exists (select null from ben_acty_base_rt_f abr1
13352: where abr1.oipl_id = p_oipl_id )))
13353: --END Option level Rates Enhancements
13354: --
13355: AND p_effective_date BETWEEN abr.effective_start_date
13403: ,ben_eligy_prfl_f elp
13404: ,ben_vrbl_rt_elig_prfl_f vep
13405: ,ben_vrbl_rt_prfl_f vpf
13406: ,ben_acty_vrbl_rt_f avr
13407: ,ben_acty_base_rt_f abr
13408: WHERE ( abr.oipl_id = p_oipl_id
13409: --
13410: --START Option level Rates Enhancements
13411: or ( abr.opt_id = l_opt_id and
13408: WHERE ( abr.oipl_id = p_oipl_id
13409: --
13410: --START Option level Rates Enhancements
13411: or ( abr.opt_id = l_opt_id and
13412: not exists (select null from ben_acty_base_rt_f abr1
13413: where abr1.oipl_id = p_oipl_id )))
13414: --END Option level Rates Enhancements
13415: --
13416: AND p_effective_date BETWEEN abr.effective_start_date
13615: FROM ben_pct_fl_tm_fctr pff
13616: ,ben_pct_fl_tm_rt_f pfr
13617: ,ben_vrbl_rt_prfl_f vpf
13618: ,ben_acty_vrbl_rt_f avr
13619: ,ben_acty_base_rt_f abr
13620: WHERE abr.plip_id = p_plip_id
13621: AND p_effective_date BETWEEN abr.effective_start_date
13622: AND abr.effective_end_date
13623: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13669: ,ben_eligy_prfl_f elp
13670: ,ben_vrbl_rt_elig_prfl_f vep
13671: ,ben_vrbl_rt_prfl_f vpf
13672: ,ben_acty_vrbl_rt_f avr
13673: ,ben_acty_base_rt_f abr
13674: WHERE abr.plip_id = p_plip_id
13675: AND p_effective_date BETWEEN abr.effective_start_date
13676: AND abr.effective_end_date
13677: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13872: FROM ben_pct_fl_tm_fctr pff
13873: ,ben_pct_fl_tm_rt_f pfr
13874: ,ben_vrbl_rt_prfl_f vpf
13875: ,ben_acty_vrbl_rt_f avr
13876: ,ben_acty_base_rt_f abr
13877: WHERE abr.ptip_id = p_ptip_id
13878: AND p_effective_date BETWEEN abr.effective_start_date
13879: AND abr.effective_end_date
13880: AND abr.acty_base_rt_id = avr.acty_base_rt_id
13926: ,ben_eligy_prfl_f elp
13927: ,ben_vrbl_rt_elig_prfl_f vep
13928: ,ben_vrbl_rt_prfl_f vpf
13929: ,ben_acty_vrbl_rt_f avr
13930: ,ben_acty_base_rt_f abr
13931: WHERE abr.ptip_id = p_ptip_id
13932: AND p_effective_date BETWEEN abr.effective_start_date
13933: AND abr.effective_end_date
13934: AND abr.acty_base_rt_id = avr.acty_base_rt_id
14129: FROM ben_pct_fl_tm_fctr pff
14130: ,ben_pct_fl_tm_rt_f pfr
14131: ,ben_vrbl_rt_prfl_f vpf
14132: ,ben_acty_vrbl_rt_f avr
14133: ,ben_acty_base_rt_f abr
14134: WHERE abr.oiplip_id = p_oiplip_id
14135: AND p_effective_date BETWEEN abr.effective_start_date
14136: AND abr.effective_end_date
14137: AND abr.acty_base_rt_id = avr.acty_base_rt_id
14183: ,ben_eligy_prfl_f elp
14184: ,ben_vrbl_rt_elig_prfl_f vep
14185: ,ben_vrbl_rt_prfl_f vpf
14186: ,ben_acty_vrbl_rt_f avr
14187: ,ben_acty_base_rt_f abr
14188: WHERE abr.oiplip_id = p_oiplip_id
14189: AND p_effective_date BETWEEN abr.effective_start_date
14190: AND abr.effective_end_date
14191: AND abr.acty_base_rt_id = avr.acty_base_rt_id
15478: FROM ben_hrs_wkd_in_perd_fctr hwf
15479: ,ben_hrs_wkd_in_perd_rt_f hwr
15480: ,ben_vrbl_rt_prfl_f vpf
15481: ,ben_acty_vrbl_rt_f avr
15482: ,ben_acty_base_rt_f abr
15483: WHERE abr.pgm_id = p_pgm_id
15484: AND p_effective_date BETWEEN abr.effective_start_date
15485: AND abr.effective_end_date
15486: AND abr.acty_base_rt_id = avr.acty_base_rt_id
15552: ,ben_eligy_prfl_f elp
15553: ,ben_vrbl_rt_elig_prfl_f vep
15554: ,ben_vrbl_rt_prfl_f vpf
15555: ,ben_acty_vrbl_rt_f avr
15556: ,ben_acty_base_rt_f abr
15557: WHERE abr.pgm_id = p_pgm_id
15558: AND p_effective_date BETWEEN abr.effective_start_date
15559: AND abr.effective_end_date
15560: AND abr.acty_base_rt_id = avr.acty_base_rt_id
15775: FROM ben_hrs_wkd_in_perd_fctr hwf
15776: ,ben_hrs_wkd_in_perd_rt_f hwr
15777: ,ben_vrbl_rt_prfl_f vpf
15778: ,ben_acty_vrbl_rt_f avr
15779: ,ben_acty_base_rt_f abr
15780: WHERE abr.pl_id = p_pl_id
15781: AND p_effective_date BETWEEN abr.effective_start_date
15782: AND abr.effective_end_date
15783: AND abr.acty_base_rt_id = avr.acty_base_rt_id
15849: ,ben_eligy_prfl_f elp
15850: ,ben_vrbl_rt_elig_prfl_f vep
15851: ,ben_vrbl_rt_prfl_f vpf
15852: ,ben_acty_vrbl_rt_f avr
15853: ,ben_acty_base_rt_f abr
15854: WHERE abr.pl_id = p_pl_id
15855: AND p_effective_date BETWEEN abr.effective_start_date
15856: AND abr.effective_end_date
15857: AND abr.acty_base_rt_id = avr.acty_base_rt_id
16074: FROM ben_hrs_wkd_in_perd_fctr hwf
16075: ,ben_hrs_wkd_in_perd_rt_f hwr
16076: ,ben_vrbl_rt_prfl_f vpf
16077: ,ben_acty_vrbl_rt_f avr
16078: ,ben_acty_base_rt_f abr
16079: WHERE ( abr.oipl_id = p_oipl_id
16080: --
16081: --START Option level Rates Enhancements
16082: or ( abr.opt_id = l_opt_id and
16079: WHERE ( abr.oipl_id = p_oipl_id
16080: --
16081: --START Option level Rates Enhancements
16082: or ( abr.opt_id = l_opt_id and
16083: not exists (select null from ben_acty_base_rt_f abr1
16084: where abr1.oipl_id = p_oipl_id )))
16085: --END Option level Rates Enhancements
16086: --
16087: AND p_effective_date BETWEEN abr.effective_start_date
16155: ,ben_eligy_prfl_f elp
16156: ,ben_vrbl_rt_elig_prfl_f vep
16157: ,ben_vrbl_rt_prfl_f vpf
16158: ,ben_acty_vrbl_rt_f avr
16159: ,ben_acty_base_rt_f abr
16160: WHERE ( abr.oipl_id = p_oipl_id
16161: --
16162: --START Option level Rates Enhancements
16163: or ( abr.opt_id = l_opt_id and
16160: WHERE ( abr.oipl_id = p_oipl_id
16161: --
16162: --START Option level Rates Enhancements
16163: or ( abr.opt_id = l_opt_id and
16164: not exists (select null from ben_acty_base_rt_f abr1
16165: where abr1.oipl_id = p_oipl_id )))
16166: --END Option level Rates Enhancements
16167: --
16168: AND p_effective_date BETWEEN abr.effective_start_date
16387: FROM ben_hrs_wkd_in_perd_fctr hwf
16388: ,ben_hrs_wkd_in_perd_rt_f hwr
16389: ,ben_vrbl_rt_prfl_f vpf
16390: ,ben_acty_vrbl_rt_f avr
16391: ,ben_acty_base_rt_f abr
16392: WHERE abr.plip_id = p_plip_id
16393: AND p_effective_date BETWEEN abr.effective_start_date
16394: AND abr.effective_end_date
16395: AND abr.acty_base_rt_id = avr.acty_base_rt_id
16461: ,ben_eligy_prfl_f elp
16462: ,ben_vrbl_rt_elig_prfl_f vep
16463: ,ben_vrbl_rt_prfl_f vpf
16464: ,ben_acty_vrbl_rt_f avr
16465: ,ben_acty_base_rt_f abr
16466: WHERE abr.plip_id = p_plip_id
16467: AND p_effective_date BETWEEN abr.effective_start_date
16468: AND abr.effective_end_date
16469: AND abr.acty_base_rt_id = avr.acty_base_rt_id
16684: FROM ben_hrs_wkd_in_perd_fctr hwf
16685: ,ben_hrs_wkd_in_perd_rt_f hwr
16686: ,ben_vrbl_rt_prfl_f vpf
16687: ,ben_acty_vrbl_rt_f avr
16688: ,ben_acty_base_rt_f abr
16689: WHERE abr.ptip_id = p_ptip_id
16690: AND p_effective_date BETWEEN abr.effective_start_date
16691: AND abr.effective_end_date
16692: AND abr.acty_base_rt_id = avr.acty_base_rt_id
16758: ,ben_eligy_prfl_f elp
16759: ,ben_vrbl_rt_elig_prfl_f vep
16760: ,ben_vrbl_rt_prfl_f vpf
16761: ,ben_acty_vrbl_rt_f avr
16762: ,ben_acty_base_rt_f abr
16763: WHERE abr.ptip_id = p_ptip_id
16764: AND p_effective_date BETWEEN abr.effective_start_date
16765: AND abr.effective_end_date
16766: AND abr.acty_base_rt_id = avr.acty_base_rt_id
16981: FROM ben_hrs_wkd_in_perd_fctr hwf
16982: ,ben_hrs_wkd_in_perd_rt_f hwr
16983: ,ben_vrbl_rt_prfl_f vpf
16984: ,ben_acty_vrbl_rt_f avr
16985: ,ben_acty_base_rt_f abr
16986: WHERE abr.oiplip_id = p_oiplip_id
16987: AND p_effective_date BETWEEN abr.effective_start_date
16988: AND abr.effective_end_date
16989: AND abr.acty_base_rt_id = avr.acty_base_rt_id
17055: ,ben_eligy_prfl_f elp
17056: ,ben_vrbl_rt_elig_prfl_f vep
17057: ,ben_vrbl_rt_prfl_f vpf
17058: ,ben_acty_vrbl_rt_f avr
17059: ,ben_acty_base_rt_f abr
17060: WHERE abr.oiplip_id = p_oiplip_id
17061: AND p_effective_date BETWEEN abr.effective_start_date
17062: AND abr.effective_end_date
17063: AND abr.acty_base_rt_id = avr.acty_base_rt_id