[Home] [Help]
1304: ,lsf.mn_los_num
1305: ,lsf.mx_los_num
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
1378: ,ben_elig_los_prte_f els
1379: ,ben_eligy_prfl_f elp
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
1599: ,lsf.mn_los_num
1600: ,lsf.mx_los_num
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
1677: ,ben_elig_los_prte_f els
1678: ,ben_eligy_prfl_f elp
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
1902: ,lsf.mn_los_num
1903: ,lsf.mx_los_num
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: --
1983: --,ben_los_rt_f lsr
1984: ,ben_elig_los_prte_f els
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: --
2217: ,lsf.mn_los_num
2218: ,lsf.mx_los_num
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
2291: --,ben_los_rt_f lsr
2292: ,ben_elig_los_prte_f els
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
2516: ,lsf.mn_los_num
2517: ,lsf.mx_los_num
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
2590: --,ben_los_rt_f lsr
2591: ,ben_elig_los_prte_f els
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
2815: ,lsf.mn_los_num
2816: ,lsf.mx_los_num
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
2889: --,ben_los_rt_f lsr
2890: ,ben_elig_los_prte_f els
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
4303: ,agf.mn_age_num
4304: ,agf.mx_age_num
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
4375: --,ben_age_rt_f art
4376: ,ben_elig_age_prte_f eap
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
4596: ,agf.mn_age_num
4597: ,agf.mx_age_num
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
4668: --,ben_age_rt_f art
4669: ,ben_elig_age_prte_f eap
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
4890: ,agf.mn_age_num
4891: ,agf.mx_age_num
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: --
4969: --,ben_age_rt_f art
4970: ,ben_elig_age_prte_f eap
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: --
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
5206: WHERE abr.plip_id = p_plip_id
5207: AND p_effective_date BETWEEN abr.effective_start_date
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
5276: ,ben_elig_age_prte_f eap
5277: --,ben_age_rt_f art
5278: ,ben_age_fctr agf
5279: WHERE abr.plip_id = p_plip_id
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
5501: WHERE abr.ptip_id = p_ptip_id
5502: AND p_effective_date BETWEEN abr.effective_start_date
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
5570: ,ben_elig_age_prte_f eap
5571: --,ben_age_rt_f art
5572: ,ben_age_fctr agf
5573: WHERE abr.ptip_id = p_ptip_id
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
5794: WHERE abr.oiplip_id = p_oiplip_id
5795: AND p_effective_date BETWEEN abr.effective_start_date
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
5863: ,ben_elig_age_prte_f eap
5864: --,ben_age_rt_f art
5865: ,ben_age_fctr agf
5866: WHERE abr.oiplip_id = p_oiplip_id
7177: ,clf.comp_lvl_fctr_id
7178: ,clf.comp_calc_rl
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
7253: --,ben_comp_lvl_rt_f clr
7254: ,ben_elig_comp_lvl_prte_f ecl
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
7478: ,clf.comp_lvl_fctr_id
7479: ,clf.comp_calc_rl
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
7554: --,ben_comp_lvl_rt_f clr
7555: ,ben_elig_comp_lvl_prte_f ecl
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
7781: ,clf.comp_lvl_fctr_id
7782: ,clf.comp_calc_rl
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: --
7864: --,ben_comp_lvl_rt_f clr
7865: ,ben_elig_comp_lvl_prte_f ecl
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: --
8098: ,clf.comp_lvl_fctr_id
8099: ,clf.comp_calc_rl
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
8174: --,ben_comp_lvl_rt_f clr
8175: ,ben_elig_comp_lvl_prte_f ecl
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
8399: ,clf.comp_lvl_fctr_id
8400: ,clf.comp_calc_rl
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
8475: --,ben_comp_lvl_rt_f clr
8476: ,ben_elig_comp_lvl_prte_f ecl
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
8700: ,clf.comp_lvl_fctr_id
8701: ,clf.comp_calc_rl
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
8776: --,ben_comp_lvl_rt_f clr
8777: ,ben_elig_comp_lvl_prte_f ecl
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
10044: ,cla.cmbnd_min_val
10045: ,cla.cmbnd_max_val
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
10111: --,ben_cmbn_age_los_rt_f cmr
10112: ,ben_elig_cmbn_age_los_prte_f ecp
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
10327: ,cla.cmbnd_min_val
10328: ,cla.cmbnd_max_val
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
10394: --,ben_cmbn_age_los_rt_f cmr
10395: ,ben_elig_cmbn_age_los_prte_f ecp
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
10612: ,cla.cmbnd_min_val
10613: ,cla.cmbnd_max_val
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: --
10686: --,ben_cmbn_age_los_rt_f cmr
10687: ,ben_elig_cmbn_age_los_prte_f ecp
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: --
10911: ,cla.cmbnd_min_val
10912: ,cla.cmbnd_max_val
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
10978: --,ben_cmbn_age_los_rt_f cmr
10979: ,ben_elig_cmbn_age_los_prte_f ecp
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
11193: ,cla.cmbnd_min_val
11194: ,cla.cmbnd_max_val
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
11260: --,ben_cmbn_age_los_rt_f cmr
11261: ,ben_elig_cmbn_age_los_prte_f ecp
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
11476: ,cla.cmbnd_min_val
11477: ,cla.cmbnd_max_val
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
11543: --,ben_cmbn_age_los_rt_f cmr
11544: ,ben_elig_cmbn_age_los_prte_f ecp
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
12824: ,pff.mn_pct_val
12825: ,pff.mx_pct_val
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
12878: --,ben_pct_fl_tm_rt_f pfr
12879: ,ben_elig_pct_fl_tm_prte_f epf
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
13081: ,pff.mn_pct_val
13082: ,pff.mx_pct_val
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
13135: --,ben_pct_fl_tm_rt_f pfr
13136: ,ben_elig_pct_fl_tm_prte_f epf
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
13340: ,pff.mn_pct_val
13341: ,pff.mx_pct_val
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: --
13401: --,ben_pct_fl_tm_rt_f pfr
13402: ,ben_elig_pct_fl_tm_prte_f epf
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: --
13613: ,pff.mn_pct_val
13614: ,pff.mx_pct_val
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
13667: --,ben_pct_fl_tm_rt_f pfr
13668: ,ben_elig_pct_fl_tm_prte_f epf
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
13870: ,pff.mn_pct_val
13871: ,pff.mx_pct_val
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
13924: --,ben_pct_fl_tm_rt_f pfr
13925: ,ben_elig_pct_fl_tm_prte_f epf
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
14127: ,pff.mn_pct_val
14128: ,pff.mx_pct_val
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
14181: --,ben_pct_fl_tm_rt_f pfr
14182: ,ben_elig_pct_fl_tm_prte_f epf
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
15476: ,hwf.once_r_cntug_cd
15477: ,hwf.hrs_wkd_calc_rl
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
15550: --,ben_hrs_wkd_in_perd_rt_f hwr
15551: ,ben_elig_hrs_wkd_prte_f ehw
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
15773: ,hwf.once_r_cntug_cd
15774: ,hwf.hrs_wkd_calc_rl
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
15847: --,ben_hrs_wkd_in_perd_rt_f hwr
15848: ,ben_elig_hrs_wkd_prte_f ehw
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
16072: ,hwf.once_r_cntug_cd
16073: ,hwf.hrs_wkd_calc_rl
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: --
16153: --,ben_hrs_wkd_in_perd_rt_f hwr
16154: ,ben_elig_hrs_wkd_prte_f ehw
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: --
16385: ,hwf.once_r_cntug_cd
16386: ,hwf.hrs_wkd_calc_rl
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
16459: --,ben_hrs_wkd_in_perd_rt_f hwr
16460: ,ben_elig_hrs_wkd_prte_f ehw
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
16682: ,hwf.once_r_cntug_cd
16683: ,hwf.hrs_wkd_calc_rl
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
16756: --,ben_hrs_wkd_in_perd_rt_f hwr
16757: ,ben_elig_hrs_wkd_prte_f ehw
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
16979: ,hwf.once_r_cntug_cd
16980: ,hwf.hrs_wkd_calc_rl
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
17053: --,ben_hrs_wkd_in_perd_rt_f hwr
17054: ,ben_elig_hrs_wkd_prte_f ehw
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