APPS.BEN_DERIVE_PART_AND_RATE_CACHE dependencies on BEN_ELIGY_PRFL_F

Line 150: ,ben_eligy_prfl_f elp

146: ,lsf.mn_los_num
147: ,lsf.mx_los_num
148: FROM ben_los_fctr lsf
149: ,ben_elig_los_prte_f els
150: ,ben_eligy_prfl_f elp
151: ,ben_prtn_elig_prfl_f cep
152: ,ben_prtn_elig_f epa
153: WHERE epa.pgm_id = p_pgm_id
154: AND p_effective_date BETWEEN epa.effective_start_date

Line 352: ,ben_eligy_prfl_f elp

348: ,lsf.mn_los_num
349: ,lsf.mx_los_num
350: FROM ben_los_fctr lsf
351: ,ben_elig_los_prte_f els
352: ,ben_eligy_prfl_f elp
353: ,ben_prtn_elig_prfl_f cep
354: ,ben_prtn_elig_f epa
355: WHERE epa.pl_id = p_pl_id
356: AND p_effective_date BETWEEN epa.effective_start_date

Line 542: ,ben_eligy_prfl_f elp

538: ,lsf.mn_los_num
539: ,lsf.mx_los_num
540: FROM ben_los_fctr lsf
541: ,ben_elig_los_prte_f els
542: ,ben_eligy_prfl_f elp
543: ,ben_prtn_elig_prfl_f cep
544: ,ben_prtn_elig_f epa
545: WHERE epa.oipl_id = p_oipl_id
546: AND p_effective_date BETWEEN epa.effective_start_date

Line 736: ,ben_eligy_prfl_f elp

732: ,lsf.mn_los_num
733: ,lsf.mx_los_num
734: FROM ben_los_fctr lsf
735: ,ben_elig_los_prte_f els
736: ,ben_eligy_prfl_f elp
737: ,ben_prtn_elig_prfl_f cep
738: ,ben_prtn_elig_f epa
739: WHERE epa.plip_id = p_plip_id
740: AND p_effective_date BETWEEN epa.effective_start_date

Line 925: ,ben_eligy_prfl_f elp

921: ,lsf.mn_los_num
922: ,lsf.mx_los_num
923: FROM ben_los_fctr lsf
924: ,ben_elig_los_prte_f els
925: ,ben_eligy_prfl_f elp
926: ,ben_prtn_elig_prfl_f cep
927: ,ben_prtn_elig_f epa
928: WHERE epa.ptip_id = p_ptip_id
929: AND p_effective_date BETWEEN epa.effective_start_date

Line 1379: ,ben_eligy_prfl_f elp

1375: FROM ben_los_fctr lsf
1376: --NEW
1377: --,ben_los_rt_f lsr
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

Line 1678: ,ben_eligy_prfl_f elp

1674: ,lsf.mx_los_num
1675: FROM ben_los_fctr lsf
1676: -- ,ben_los_rt_f lsr
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

Line 1985: ,ben_eligy_prfl_f elp

1981: ,lsf.mx_los_num
1982: FROM ben_los_fctr lsf
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

Line 2293: ,ben_eligy_prfl_f elp

2289: ,lsf.mx_los_num
2290: FROM ben_los_fctr lsf
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

Line 2592: ,ben_eligy_prfl_f elp

2588: ,lsf.mx_los_num
2589: FROM ben_los_fctr lsf
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

Line 2891: ,ben_eligy_prfl_f elp

2887: ,lsf.mx_los_num
2888: FROM ben_los_fctr lsf
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

Line 3195: ,ben_eligy_prfl_f elp

3191: ,agf.mn_age_num
3192: ,agf.mx_age_num
3193: FROM ben_age_fctr agf
3194: ,ben_elig_age_prte_f eap
3195: ,ben_eligy_prfl_f elp
3196: ,ben_prtn_elig_prfl_f cep
3197: ,ben_prtn_elig_f epa
3198: WHERE epa.pgm_id = p_pgm_id
3199: AND p_effective_date BETWEEN epa.effective_start_date

Line 3380: ,ben_eligy_prfl_f elp

3376: ,agf.mn_age_num
3377: ,agf.mx_age_num
3378: FROM ben_age_fctr agf
3379: ,ben_elig_age_prte_f eap
3380: ,ben_eligy_prfl_f elp
3381: ,ben_prtn_elig_prfl_f cep
3382: ,ben_prtn_elig_f epa
3383: WHERE epa.pl_id = p_pl_id
3384: AND p_effective_date BETWEEN epa.effective_start_date

Line 3564: ,ben_eligy_prfl_f elp

3560: ,agf.mn_age_num
3561: ,agf.mx_age_num
3562: FROM ben_age_fctr agf
3563: ,ben_elig_age_prte_f eap
3564: ,ben_eligy_prfl_f elp
3565: ,ben_prtn_elig_prfl_f cep
3566: ,ben_prtn_elig_f epa
3567: WHERE epa.oipl_id = p_oipl_id
3568: AND p_effective_date BETWEEN epa.effective_start_date

Line 3748: ,ben_eligy_prfl_f elp

3744: ,agf.mn_age_num
3745: ,agf.mx_age_num
3746: FROM ben_age_fctr agf
3747: ,ben_elig_age_prte_f eap
3748: ,ben_eligy_prfl_f elp
3749: ,ben_prtn_elig_prfl_f cep
3750: ,ben_prtn_elig_f epa
3751: WHERE epa.plip_id = p_plip_id
3752: AND p_effective_date BETWEEN epa.effective_start_date

Line 3932: ,ben_eligy_prfl_f elp

3928: ,agf.mn_age_num
3929: ,agf.mx_age_num
3930: FROM ben_age_fctr agf
3931: ,ben_elig_age_prte_f eap
3932: ,ben_eligy_prfl_f elp
3933: ,ben_prtn_elig_prfl_f cep
3934: ,ben_prtn_elig_f epa
3935: WHERE epa.ptip_id = p_ptip_id
3936: AND p_effective_date BETWEEN epa.effective_start_date

Line 4377: ,ben_eligy_prfl_f elp

4373: ,agf.mx_age_num
4374: FROM ben_age_fctr agf
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

Line 4670: ,ben_eligy_prfl_f elp

4666: ,agf.mx_age_num
4667: FROM ben_age_fctr agf
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

Line 4971: ,ben_eligy_prfl_f elp

4967: ,agf.mx_age_num
4968: FROM ben_age_fctr agf
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

Line 5273: ,ben_eligy_prfl_f elp

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
5276: ,ben_elig_age_prte_f eap
5277: --,ben_age_rt_f art

Line 5567: ,ben_eligy_prfl_f elp

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
5570: ,ben_elig_age_prte_f eap
5571: --,ben_age_rt_f art

Line 5860: ,ben_eligy_prfl_f elp

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
5863: ,ben_elig_age_prte_f eap
5864: --,ben_age_rt_f art

Line 6167: ,ben_eligy_prfl_f elp

6163: ,clf.comp_lvl_fctr_id
6164: ,clf.comp_calc_rl
6165: FROM ben_comp_lvl_fctr clf
6166: ,ben_elig_comp_lvl_prte_f ecl
6167: ,ben_eligy_prfl_f elp
6168: ,ben_prtn_elig_prfl_f cep
6169: ,ben_prtn_elig_f epa
6170: WHERE epa.pgm_id = p_pgm_id
6171: AND p_effective_date BETWEEN epa.effective_start_date

Line 6356: ,ben_eligy_prfl_f elp

6352: ,clf.comp_lvl_fctr_id
6353: ,clf.comp_calc_rl
6354: FROM ben_comp_lvl_fctr clf
6355: ,ben_elig_comp_lvl_prte_f ecl
6356: ,ben_eligy_prfl_f elp
6357: ,ben_prtn_elig_prfl_f cep
6358: ,ben_prtn_elig_f epa
6359: WHERE epa.pl_id = p_pl_id
6360: AND p_effective_date BETWEEN epa.effective_start_date

Line 6544: ,ben_eligy_prfl_f elp

6540: ,clf.comp_lvl_fctr_id
6541: ,clf.comp_calc_rl
6542: FROM ben_comp_lvl_fctr clf
6543: ,ben_elig_comp_lvl_prte_f ecl
6544: ,ben_eligy_prfl_f elp
6545: ,ben_prtn_elig_prfl_f cep
6546: ,ben_prtn_elig_f epa
6547: WHERE epa.oipl_id = p_oipl_id
6548: AND p_effective_date BETWEEN epa.effective_start_date

Line 6732: ,ben_eligy_prfl_f elp

6728: ,clf.comp_lvl_fctr_id
6729: ,clf.comp_calc_rl
6730: FROM ben_comp_lvl_fctr clf
6731: ,ben_elig_comp_lvl_prte_f ecl
6732: ,ben_eligy_prfl_f elp
6733: ,ben_prtn_elig_prfl_f cep
6734: ,ben_prtn_elig_f epa
6735: WHERE epa.plip_id = p_plip_id
6736: AND p_effective_date BETWEEN epa.effective_start_date

Line 6920: ,ben_eligy_prfl_f elp

6916: ,clf.comp_lvl_fctr_id
6917: ,clf.comp_calc_rl
6918: FROM ben_comp_lvl_fctr clf
6919: ,ben_elig_comp_lvl_prte_f ecl
6920: ,ben_eligy_prfl_f elp
6921: ,ben_prtn_elig_prfl_f cep
6922: ,ben_prtn_elig_f epa
6923: WHERE epa.ptip_id = p_ptip_id
6924: AND p_effective_date BETWEEN epa.effective_start_date

Line 7255: ,ben_eligy_prfl_f elp

7251: ,clf.comp_calc_rl
7252: FROM ben_comp_lvl_fctr clf
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

Line 7556: ,ben_eligy_prfl_f elp

7552: ,clf.comp_calc_rl
7553: FROM ben_comp_lvl_fctr clf
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

Line 7866: ,ben_eligy_prfl_f elp

7862: ,clf.comp_calc_rl
7863: FROM ben_comp_lvl_fctr clf
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

Line 8176: ,ben_eligy_prfl_f elp

8172: ,clf.comp_calc_rl
8173: FROM ben_comp_lvl_fctr clf
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

Line 8477: ,ben_eligy_prfl_f elp

8473: ,clf.comp_calc_rl
8474: FROM ben_comp_lvl_fctr clf
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

Line 8778: ,ben_eligy_prfl_f elp

8774: ,clf.comp_calc_rl
8775: FROM ben_comp_lvl_fctr clf
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

Line 9075: ,ben_eligy_prfl_f elp

9071: ,cla.cmbnd_min_val
9072: ,cla.cmbnd_max_val
9073: FROM ben_cmbn_age_los_fctr cla
9074: ,ben_elig_cmbn_age_los_prte_f ecp
9075: ,ben_eligy_prfl_f elp
9076: ,ben_prtn_elig_prfl_f cep
9077: ,ben_prtn_elig_f epa
9078: WHERE epa.pgm_id = p_pgm_id
9079: AND p_effective_date BETWEEN epa.effective_start_date

Line 9255: ,ben_eligy_prfl_f elp

9251: ,cla.cmbnd_min_val
9252: ,cla.cmbnd_max_val
9253: FROM ben_cmbn_age_los_fctr cla
9254: ,ben_elig_cmbn_age_los_prte_f ecp
9255: ,ben_eligy_prfl_f elp
9256: ,ben_prtn_elig_prfl_f cep
9257: ,ben_prtn_elig_f epa
9258: WHERE epa.pl_id = p_pl_id
9259: AND p_effective_date BETWEEN epa.effective_start_date

Line 9435: ,ben_eligy_prfl_f elp

9431: ,cla.cmbnd_min_val
9432: ,cla.cmbnd_max_val
9433: FROM ben_cmbn_age_los_fctr cla
9434: ,ben_elig_cmbn_age_los_prte_f ecp
9435: ,ben_eligy_prfl_f elp
9436: ,ben_prtn_elig_prfl_f cep
9437: ,ben_prtn_elig_f epa
9438: WHERE epa.oipl_id = p_oipl_id
9439: AND p_effective_date BETWEEN epa.effective_start_date

Line 9615: ,ben_eligy_prfl_f elp

9611: ,cla.cmbnd_min_val
9612: ,cla.cmbnd_max_val
9613: FROM ben_cmbn_age_los_fctr cla
9614: ,ben_elig_cmbn_age_los_prte_f ecp
9615: ,ben_eligy_prfl_f elp
9616: ,ben_prtn_elig_prfl_f cep
9617: ,ben_prtn_elig_f epa
9618: WHERE epa.plip_id = p_plip_id
9619: AND p_effective_date BETWEEN epa.effective_start_date

Line 9795: ,ben_eligy_prfl_f elp

9791: ,cla.cmbnd_min_val
9792: ,cla.cmbnd_max_val
9793: FROM ben_cmbn_age_los_fctr cla
9794: ,ben_elig_cmbn_age_los_prte_f ecp
9795: ,ben_eligy_prfl_f elp
9796: ,ben_prtn_elig_prfl_f cep
9797: ,ben_prtn_elig_f epa
9798: WHERE epa.ptip_id = p_ptip_id
9799: AND p_effective_date BETWEEN epa.effective_start_date

Line 10113: ,ben_eligy_prfl_f elp

10109: ,cla.cmbnd_max_val
10110: FROM ben_cmbn_age_los_fctr cla
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

Line 10396: ,ben_eligy_prfl_f elp

10392: ,cla.cmbnd_max_val
10393: FROM ben_cmbn_age_los_fctr cla
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

Line 10688: ,ben_eligy_prfl_f elp

10684: ,cla.cmbnd_max_val
10685: FROM ben_cmbn_age_los_fctr cla
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

Line 10980: ,ben_eligy_prfl_f elp

10976: ,cla.cmbnd_max_val
10977: FROM ben_cmbn_age_los_fctr cla
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

Line 11262: ,ben_eligy_prfl_f elp

11258: ,cla.cmbnd_max_val
11259: FROM ben_cmbn_age_los_fctr cla
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

Line 11545: ,ben_eligy_prfl_f elp

11541: ,cla.cmbnd_max_val
11542: FROM ben_cmbn_age_los_fctr cla
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

Line 11844: ,ben_eligy_prfl_f elp

11840: ,pff.mn_pct_val
11841: ,pff.mx_pct_val
11842: FROM ben_pct_fl_tm_fctr pff
11843: ,ben_elig_pct_fl_tm_prte_f epf
11844: ,ben_eligy_prfl_f elp
11845: ,ben_prtn_elig_prfl_f cep
11846: ,ben_prtn_elig_f epa
11847: WHERE epa.pgm_id = p_pgm_id
11848: AND p_effective_date BETWEEN epa.effective_start_date

Line 12027: ,ben_eligy_prfl_f elp

12023: ,pff.mn_pct_val
12024: ,pff.mx_pct_val
12025: FROM ben_pct_fl_tm_fctr pff
12026: ,ben_elig_pct_fl_tm_prte_f epf
12027: ,ben_eligy_prfl_f elp
12028: ,ben_prtn_elig_prfl_f cep
12029: ,ben_prtn_elig_f epa
12030: WHERE epa.pl_id = p_pl_id
12031: AND p_effective_date BETWEEN epa.effective_start_date

Line 12209: ,ben_eligy_prfl_f elp

12205: ,pff.mn_pct_val
12206: ,pff.mx_pct_val
12207: FROM ben_pct_fl_tm_fctr pff
12208: ,ben_elig_pct_fl_tm_prte_f epf
12209: ,ben_eligy_prfl_f elp
12210: ,ben_prtn_elig_prfl_f cep
12211: ,ben_prtn_elig_f epa
12212: WHERE epa.oipl_id = p_oipl_id
12213: AND p_effective_date BETWEEN epa.effective_start_date

Line 12391: ,ben_eligy_prfl_f elp

12387: ,pff.mn_pct_val
12388: ,pff.mx_pct_val
12389: FROM ben_pct_fl_tm_fctr pff
12390: ,ben_elig_pct_fl_tm_prte_f epf
12391: ,ben_eligy_prfl_f elp
12392: ,ben_prtn_elig_prfl_f cep
12393: ,ben_prtn_elig_f epa
12394: WHERE epa.plip_id = p_plip_id
12395: AND p_effective_date BETWEEN epa.effective_start_date

Line 12573: ,ben_eligy_prfl_f elp

12569: ,pff.mn_pct_val
12570: ,pff.mx_pct_val
12571: FROM ben_pct_fl_tm_fctr pff
12572: ,ben_elig_pct_fl_tm_prte_f epf
12573: ,ben_eligy_prfl_f elp
12574: ,ben_prtn_elig_prfl_f cep
12575: ,ben_prtn_elig_f epa
12576: WHERE epa.ptip_id = p_ptip_id
12577: AND p_effective_date BETWEEN epa.effective_start_date

Line 12880: ,ben_eligy_prfl_f elp

12876: ,pff.mx_pct_val
12877: FROM ben_pct_fl_tm_fctr pff
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

Line 13137: ,ben_eligy_prfl_f elp

13133: ,pff.mx_pct_val
13134: FROM ben_pct_fl_tm_fctr pff
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

Line 13403: ,ben_eligy_prfl_f elp

13399: ,pff.mx_pct_val
13400: FROM ben_pct_fl_tm_fctr pff
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

Line 13669: ,ben_eligy_prfl_f elp

13665: ,pff.mx_pct_val
13666: FROM ben_pct_fl_tm_fctr pff
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

Line 13926: ,ben_eligy_prfl_f elp

13922: ,pff.mx_pct_val
13923: FROM ben_pct_fl_tm_fctr pff
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

Line 14183: ,ben_eligy_prfl_f elp

14179: ,pff.mx_pct_val
14180: FROM ben_pct_fl_tm_fctr pff
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

Line 14472: ,ben_eligy_prfl_f elp

14468: ,hwf.once_r_cntug_cd
14469: ,hwf.hrs_wkd_calc_rl
14470: FROM ben_hrs_wkd_in_perd_fctr hwf
14471: ,ben_elig_hrs_wkd_prte_f ehw
14472: ,ben_eligy_prfl_f elp
14473: ,ben_prtn_elig_prfl_f cep
14474: ,ben_prtn_elig_f epa
14475: WHERE epa.pgm_id = p_pgm_id
14476: AND p_effective_date BETWEEN epa.effective_start_date

Line 14659: ,ben_eligy_prfl_f elp

14655: ,hwf.once_r_cntug_cd
14656: ,hwf.hrs_wkd_calc_rl
14657: FROM ben_hrs_wkd_in_perd_fctr hwf
14658: ,ben_elig_hrs_wkd_prte_f ehw
14659: ,ben_eligy_prfl_f elp
14660: ,ben_prtn_elig_prfl_f cep
14661: ,ben_prtn_elig_f epa
14662: WHERE epa.pl_id = p_pl_id
14663: AND p_effective_date BETWEEN epa.effective_start_date

Line 14846: ,ben_eligy_prfl_f elp

14842: ,hwf.once_r_cntug_cd
14843: ,hwf.hrs_wkd_calc_rl
14844: FROM ben_hrs_wkd_in_perd_fctr hwf
14845: ,ben_elig_hrs_wkd_prte_f ehw
14846: ,ben_eligy_prfl_f elp
14847: ,ben_prtn_elig_prfl_f cep
14848: ,ben_prtn_elig_f epa
14849: WHERE epa.oipl_id = p_oipl_id
14850: AND p_effective_date BETWEEN epa.effective_start_date

Line 15033: ,ben_eligy_prfl_f elp

15029: ,hwf.once_r_cntug_cd
15030: ,hwf.hrs_wkd_calc_rl
15031: FROM ben_hrs_wkd_in_perd_fctr hwf
15032: ,ben_elig_hrs_wkd_prte_f ehw
15033: ,ben_eligy_prfl_f elp
15034: ,ben_prtn_elig_prfl_f cep
15035: ,ben_prtn_elig_f epa
15036: WHERE epa.plip_id = p_plip_id
15037: AND p_effective_date BETWEEN epa.effective_start_date

Line 15220: ,ben_eligy_prfl_f elp

15216: ,hwf.once_r_cntug_cd
15217: ,hwf.hrs_wkd_calc_rl
15218: FROM ben_hrs_wkd_in_perd_fctr hwf
15219: ,ben_elig_hrs_wkd_prte_f ehw
15220: ,ben_eligy_prfl_f elp
15221: ,ben_prtn_elig_prfl_f cep
15222: ,ben_prtn_elig_f epa
15223: WHERE epa.ptip_id = p_ptip_id
15224: AND p_effective_date BETWEEN epa.effective_start_date

Line 15552: ,ben_eligy_prfl_f elp

15548: ,hwf.hrs_wkd_calc_rl
15549: FROM ben_hrs_wkd_in_perd_fctr hwf
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

Line 15849: ,ben_eligy_prfl_f elp

15845: ,hwf.hrs_wkd_calc_rl
15846: FROM ben_hrs_wkd_in_perd_fctr hwf
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

Line 16155: ,ben_eligy_prfl_f elp

16151: ,hwf.hrs_wkd_calc_rl
16152: FROM ben_hrs_wkd_in_perd_fctr hwf
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

Line 16461: ,ben_eligy_prfl_f elp

16457: ,hwf.hrs_wkd_calc_rl
16458: FROM ben_hrs_wkd_in_perd_fctr hwf
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

Line 16758: ,ben_eligy_prfl_f elp

16754: ,hwf.hrs_wkd_calc_rl
16755: FROM ben_hrs_wkd_in_perd_fctr hwf
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

Line 17055: ,ben_eligy_prfl_f elp

17051: ,hwf.hrs_wkd_calc_rl
17052: FROM ben_hrs_wkd_in_perd_fctr hwf
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