[Home] [Help]
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
156: AND epa.prtn_elig_id = cep.prtn_elig_id
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
358: AND epa.prtn_elig_id = cep.prtn_elig_id
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
548: AND epa.prtn_elig_id = cep.prtn_elig_id
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
742: AND epa.prtn_elig_id = cep.prtn_elig_id
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
931: AND epa.prtn_elig_id = cep.prtn_elig_id
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
3201: AND epa.prtn_elig_id = cep.prtn_elig_id
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
3386: AND epa.prtn_elig_id = cep.prtn_elig_id
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
3570: AND epa.prtn_elig_id = cep.prtn_elig_id
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
3754: AND epa.prtn_elig_id = cep.prtn_elig_id
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
3938: AND epa.prtn_elig_id = cep.prtn_elig_id
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
6173: AND epa.prtn_elig_id = cep.prtn_elig_id
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
6362: AND epa.prtn_elig_id = cep.prtn_elig_id
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
6550: AND epa.prtn_elig_id = cep.prtn_elig_id
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
6738: AND epa.prtn_elig_id = cep.prtn_elig_id
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
6926: AND epa.prtn_elig_id = cep.prtn_elig_id
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
9081: AND epa.prtn_elig_id = cep.prtn_elig_id
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
9261: AND epa.prtn_elig_id = cep.prtn_elig_id
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
9441: AND epa.prtn_elig_id = cep.prtn_elig_id
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
9621: AND epa.prtn_elig_id = cep.prtn_elig_id
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
9801: AND epa.prtn_elig_id = cep.prtn_elig_id
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
11850: AND epa.prtn_elig_id = cep.prtn_elig_id
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
12033: AND epa.prtn_elig_id = cep.prtn_elig_id
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
12215: AND epa.prtn_elig_id = cep.prtn_elig_id
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
12397: AND epa.prtn_elig_id = cep.prtn_elig_id
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
12579: AND epa.prtn_elig_id = cep.prtn_elig_id
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
14478: AND epa.prtn_elig_id = cep.prtn_elig_id
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
14665: AND epa.prtn_elig_id = cep.prtn_elig_id
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
14852: AND epa.prtn_elig_id = cep.prtn_elig_id
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
15039: AND epa.prtn_elig_id = cep.prtn_elig_id
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
15226: AND epa.prtn_elig_id = cep.prtn_elig_id