APPS.BEN_DERIVE_PART_AND_RATE_CACHE dependencies on BEN_PRTN_ELIG_PRFL_F

Line 151: ,ben_prtn_elig_prfl_f cep

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
155: AND epa.effective_end_date

Line 353: ,ben_prtn_elig_prfl_f cep

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
357: AND epa.effective_end_date

Line 543: ,ben_prtn_elig_prfl_f cep

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
547: AND epa.effective_end_date

Line 737: ,ben_prtn_elig_prfl_f cep

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
741: AND epa.effective_end_date

Line 926: ,ben_prtn_elig_prfl_f cep

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
930: AND epa.effective_end_date

Line 3196: ,ben_prtn_elig_prfl_f cep

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
3200: AND epa.effective_end_date

Line 3381: ,ben_prtn_elig_prfl_f cep

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
3385: AND epa.effective_end_date

Line 3565: ,ben_prtn_elig_prfl_f cep

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
3569: AND epa.effective_end_date

Line 3749: ,ben_prtn_elig_prfl_f cep

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
3753: AND epa.effective_end_date

Line 3933: ,ben_prtn_elig_prfl_f cep

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
3937: AND epa.effective_end_date

Line 6168: ,ben_prtn_elig_prfl_f cep

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
6172: AND epa.effective_end_date

Line 6357: ,ben_prtn_elig_prfl_f cep

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
6361: AND epa.effective_end_date

Line 6545: ,ben_prtn_elig_prfl_f cep

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
6549: AND epa.effective_end_date

Line 6733: ,ben_prtn_elig_prfl_f cep

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
6737: AND epa.effective_end_date

Line 6921: ,ben_prtn_elig_prfl_f cep

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
6925: AND epa.effective_end_date

Line 9076: ,ben_prtn_elig_prfl_f cep

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
9080: AND epa.effective_end_date

Line 9256: ,ben_prtn_elig_prfl_f cep

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
9260: AND epa.effective_end_date

Line 9436: ,ben_prtn_elig_prfl_f cep

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
9440: AND epa.effective_end_date

Line 9616: ,ben_prtn_elig_prfl_f cep

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
9620: AND epa.effective_end_date

Line 9796: ,ben_prtn_elig_prfl_f cep

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
9800: AND epa.effective_end_date

Line 11845: ,ben_prtn_elig_prfl_f cep

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
11849: AND epa.effective_end_date

Line 12028: ,ben_prtn_elig_prfl_f cep

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
12032: AND epa.effective_end_date

Line 12210: ,ben_prtn_elig_prfl_f cep

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
12214: AND epa.effective_end_date

Line 12392: ,ben_prtn_elig_prfl_f cep

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
12396: AND epa.effective_end_date

Line 12574: ,ben_prtn_elig_prfl_f cep

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
12578: AND epa.effective_end_date

Line 14473: ,ben_prtn_elig_prfl_f cep

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
14477: AND epa.effective_end_date

Line 14660: ,ben_prtn_elig_prfl_f cep

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
14664: AND epa.effective_end_date

Line 14847: ,ben_prtn_elig_prfl_f cep

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
14851: AND epa.effective_end_date

Line 15034: ,ben_prtn_elig_prfl_f cep

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
15038: AND epa.effective_end_date

Line 15221: ,ben_prtn_elig_prfl_f cep

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
15225: AND epa.effective_end_date