386: --
387: hr_utility.set_location('Entering'||l_proc, 5);
388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
387: hr_utility.set_location('Entering'||l_proc, 5);
388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
388: hr_utility.set_location('p_elig_per_elctbl_chc_id '|| p_elig_per_elctbl_chc_id , 5);
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
396: ben_ext_person.g_elig_ttl_other_rate := null ;
389:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
396: ben_ext_person.g_elig_ttl_other_rate := null ;
397:
390: ben_ext_person.g_elig_ee_pre_tax_cost := null ;
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
396: ben_ext_person.g_elig_ttl_other_rate := null ;
397:
398: --
391: ben_ext_person.g_elig_ee_after_tax_cost := null ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
396: ben_ext_person.g_elig_ttl_other_rate := null ;
397:
398: --
399: l_rate_total := 0 ;
392: ben_ext_person.g_elig_ee_ttl_cost := null ;
393: ben_ext_person.g_elig_er_ttl_cost := null ;
394: ben_ext_person.g_elig_ee_ttl_distribution := null ;
395: ben_ext_person.g_elig_er_ttl_distribution := null ;
396: ben_ext_person.g_elig_ttl_other_rate := null ;
397:
398: --
399: l_rate_total := 0 ;
400: l_enb_rate_total := 0 ;
407: fetch ee_pre_tax_enb_c into l_enb_rate_total;
408: close ee_pre_tax_enb_c;
409:
410: if l_rate_total is not null or l_enb_rate_total is not null then
411: ben_ext_person.g_elig_ee_pre_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
412: end if ;
413: hr_utility.set_location('g_elig_ee_pre_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_pre_tax_cost , 5);
414: --
415: l_rate_total := 0 ;
409:
410: if l_rate_total is not null or l_enb_rate_total is not null then
411: ben_ext_person.g_elig_ee_pre_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
412: end if ;
413: hr_utility.set_location('g_elig_ee_pre_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_pre_tax_cost , 5);
414: --
415: l_rate_total := 0 ;
416: l_enb_rate_total := 0 ;
417:
423: fetch ee_after_tax_enb_c into l_enb_rate_total;
424: close ee_after_tax_enb_c;
425:
426: if l_rate_total is not null or l_enb_rate_total is not null then
427: ben_ext_person.g_elig_ee_after_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
428: end if ;
429:
430: hr_utility.set_location('g_elig_ee_after_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_after_tax_cost , 5);
431: --
426: if l_rate_total is not null or l_enb_rate_total is not null then
427: ben_ext_person.g_elig_ee_after_tax_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
428: end if ;
429:
430: hr_utility.set_location('g_elig_ee_after_tax_cost '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_after_tax_cost , 5);
431: --
432: l_rate_total := 0 ;
433: l_enb_rate_total := 0 ;
434:
442: close ee_ttl_enb_c;
443:
444:
445: if l_rate_total is not null or l_enb_rate_total is not null then
446: ben_ext_person.g_elig_ee_ttl_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
447: end if ;
448: --
449:
450: l_rate_total := 0 ;
458: fetch er_ttl_enb_c into l_enb_rate_total;
459: close er_ttl_enb_c;
460:
461: if l_rate_total is not null or l_enb_rate_total is not null then
462: ben_ext_person.g_elig_er_ttl_cost := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
463: end if ;
464: --
465: l_rate_total := 0 ;
466: l_enb_rate_total := 0 ;
474: fetch ee_ttl_dist_enb_c into l_enb_rate_total;
475: close ee_ttl_dist_enb_c;
476:
477: if l_rate_total is not null or l_enb_rate_total is not null then
478: ben_ext_person.g_elig_ee_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
479: end if ;
480: hr_utility.set_location('g_elig_ee_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_ttl_distribution , 5);
481: --
482:
476:
477: if l_rate_total is not null or l_enb_rate_total is not null then
478: ben_ext_person.g_elig_ee_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
479: end if ;
480: hr_utility.set_location('g_elig_ee_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_ee_ttl_distribution , 5);
481: --
482:
483: l_rate_total := 0 ;
484: l_enb_rate_total := 0 ;
492: fetch er_ttl_dist_enb_c into l_enb_rate_total;
493: close er_ttl_dist_enb_c;
494:
495: if l_rate_total is not null or l_enb_rate_total is not null then
496: ben_ext_person.g_elig_er_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
497: end if ;
498: hr_utility.set_location('g_elig_er_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_er_ttl_distribution , 5);
499: --
500: l_rate_total := 0 ;
494:
495: if l_rate_total is not null or l_enb_rate_total is not null then
496: ben_ext_person.g_elig_er_ttl_distribution := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
497: end if ;
498: hr_utility.set_location('g_elig_er_ttl_distribution '|| nvl(l_rate_total,0) ||'/'||nvl(l_enb_rate_total,0)||'/'|| ben_ext_person.g_elig_er_ttl_distribution , 5);
499: --
500: l_rate_total := 0 ;
501: l_enb_rate_total := 0 ;
502:
508: fetch ttl_oth_rt_enb_c into l_enb_rate_total;
509: close ttl_oth_rt_enb_c;
510:
511: if l_rate_total is not null or l_enb_rate_total is not null then
512: ben_ext_person.g_elig_ttl_other_rate := nvl(l_rate_total,0) + nvl(l_enb_rate_total,0) ;
513: end if ;
514:
515: --
516: open c_min_max_rt1;
514:
515: --
516: open c_min_max_rt1;
517: fetch c_min_max_rt1 into
518: ben_ext_person.g_elig_min_amt,
519: ben_ext_person.g_elig_max_amt,
520: ben_ext_person.g_elig_incr_amt,
521: ben_ext_person.g_elig_dflt_amt;
522: -- if not found then try another path.
515: --
516: open c_min_max_rt1;
517: fetch c_min_max_rt1 into
518: ben_ext_person.g_elig_min_amt,
519: ben_ext_person.g_elig_max_amt,
520: ben_ext_person.g_elig_incr_amt,
521: ben_ext_person.g_elig_dflt_amt;
522: -- if not found then try another path.
523: if c_min_max_rt1%NOTFOUND then
516: open c_min_max_rt1;
517: fetch c_min_max_rt1 into
518: ben_ext_person.g_elig_min_amt,
519: ben_ext_person.g_elig_max_amt,
520: ben_ext_person.g_elig_incr_amt,
521: ben_ext_person.g_elig_dflt_amt;
522: -- if not found then try another path.
523: if c_min_max_rt1%NOTFOUND then
524: open c_min_max_rt2;
517: fetch c_min_max_rt1 into
518: ben_ext_person.g_elig_min_amt,
519: ben_ext_person.g_elig_max_amt,
520: ben_ext_person.g_elig_incr_amt,
521: ben_ext_person.g_elig_dflt_amt;
522: -- if not found then try another path.
523: if c_min_max_rt1%NOTFOUND then
524: open c_min_max_rt2;
525: fetch c_min_max_rt2 into
522: -- if not found then try another path.
523: if c_min_max_rt1%NOTFOUND then
524: open c_min_max_rt2;
525: fetch c_min_max_rt2 into
526: ben_ext_person.g_elig_min_amt,
527: ben_ext_person.g_elig_max_amt,
528: ben_ext_person.g_elig_incr_amt,
529: ben_ext_person.g_elig_dflt_amt;
530: close c_min_max_rt2;
523: if c_min_max_rt1%NOTFOUND then
524: open c_min_max_rt2;
525: fetch c_min_max_rt2 into
526: ben_ext_person.g_elig_min_amt,
527: ben_ext_person.g_elig_max_amt,
528: ben_ext_person.g_elig_incr_amt,
529: ben_ext_person.g_elig_dflt_amt;
530: close c_min_max_rt2;
531: end if;
524: open c_min_max_rt2;
525: fetch c_min_max_rt2 into
526: ben_ext_person.g_elig_min_amt,
527: ben_ext_person.g_elig_max_amt,
528: ben_ext_person.g_elig_incr_amt,
529: ben_ext_person.g_elig_dflt_amt;
530: close c_min_max_rt2;
531: end if;
532: --
525: fetch c_min_max_rt2 into
526: ben_ext_person.g_elig_min_amt,
527: ben_ext_person.g_elig_max_amt,
528: ben_ext_person.g_elig_incr_amt,
529: ben_ext_person.g_elig_dflt_amt;
530: close c_min_max_rt2;
531: end if;
532: --
533: close c_min_max_rt1;
533: close c_min_max_rt1;
534: --
535: --cwb 2832419
536: open ttl_type_cd_c('CWBDB');
537: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_dst_bdgt;
538: close ttl_type_cd_c ;
539:
540: open ttl_type_cd_c('CWBES');
541: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_elig_salary;
537: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_dst_bdgt;
538: close ttl_type_cd_c ;
539:
540: open ttl_type_cd_c('CWBES');
541: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_elig_salary;
542: close ttl_type_cd_c ;
543:
544: open ttl_type_cd_c('CWBGP');
545: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_grant_price;
541: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_elig_salary;
542: close ttl_type_cd_c ;
543:
544: open ttl_type_cd_c('CWBGP');
545: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_grant_price;
546: close ttl_type_cd_c ;
547:
548:
549: open ttl_type_cd_c('CWBMR1');
546: close ttl_type_cd_c ;
547:
548:
549: open ttl_type_cd_c('CWBMR1');
550: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_1;
551: close ttl_type_cd_c ;
552:
553: open ttl_type_cd_c('CWBMR2');
554: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_2;
550: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_1;
551: close ttl_type_cd_c ;
552:
553: open ttl_type_cd_c('CWBMR2');
554: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_2;
555: close ttl_type_cd_c ;
556:
557: open ttl_type_cd_c('CWBMR3');
558: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_3;
554: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_2;
555: close ttl_type_cd_c ;
556:
557: open ttl_type_cd_c('CWBMR3');
558: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_3;
559: close ttl_type_cd_c ;
560:
561: open ttl_type_cd_c('CWBOS');
562: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_other_salary;
558: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_misc_rate_3;
559: close ttl_type_cd_c ;
560:
561: open ttl_type_cd_c('CWBOS');
562: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_other_salary;
563: close ttl_type_cd_c ;
564:
565: open ttl_type_cd_c('CWBR');
566: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_reserve ;
562: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_other_salary;
563: close ttl_type_cd_c ;
564:
565: open ttl_type_cd_c('CWBR');
566: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_reserve ;
567: close ttl_type_cd_c ;
568:
569: open ttl_type_cd_c('CWBRA');
570: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_recomond_amt;
566: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_reserve ;
567: close ttl_type_cd_c ;
568:
569: open ttl_type_cd_c('CWBRA');
570: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_recomond_amt;
571: close ttl_type_cd_c ;
572:
573: open ttl_type_cd_c('CWBSS');
574: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_stated_salary;
570: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_recomond_amt;
571: close ttl_type_cd_c ;
572:
573: open ttl_type_cd_c('CWBSS');
574: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_stated_salary;
575: close ttl_type_cd_c ;
576:
577: open ttl_type_cd_c('CWBTC');
578: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_tot_compensation;
574: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_stated_salary;
575: close ttl_type_cd_c ;
576:
577: open ttl_type_cd_c('CWBTC');
578: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_tot_compensation;
579: close ttl_type_cd_c ;
580:
581: open ttl_type_cd_c('CWBWB');
582: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_bdgt;
578: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_tot_compensation;
579: close ttl_type_cd_c ;
580:
581: open ttl_type_cd_c('CWBWB');
582: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_bdgt;
583: close ttl_type_cd_c ;
584:
585: open ttl_type_cd_c('CWBWS');
586: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_amt;
582: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_bdgt;
583: close ttl_type_cd_c ;
584:
585: open ttl_type_cd_c('CWBWS');
586: fetch ttl_type_cd_c into ben_ext_person.g_elig_ee_cwb_worksheet_amt;
587: close ttl_type_cd_c ;
588:
589: hr_utility.set_location('Exiting'||l_proc, 15);
590: --
601: Begin
602: --
603: hr_utility.set_location('Entering'||l_proc, 5);
604: --
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
602: --
603: hr_utility.set_location('Entering'||l_proc, 5);
604: --
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
603: hr_utility.set_location('Entering'||l_proc, 5);
604: --
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
604: --
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
605: ben_ext_person.g_elig_enrt_strt_dt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
606: ben_ext_person.g_elig_enrt_end_dt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
607: ben_ext_person.g_elig_dflt_enrt_dt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
608: ben_ext_person.g_elig_uom := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
609: ben_ext_person.g_elig_pl_name := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
610: ben_ext_person.g_elig_opt_name := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
611: ben_ext_person.g_elig_cvg_amt := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
612: ben_ext_person.g_elig_cvg_min_amt := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
613: ben_ext_person.g_elig_cvg_max_amt := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
614: ben_ext_person.g_elig_cvg_inc_amt := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
615: ben_ext_person.g_elig_cvg_dfl_amt := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
616: ben_ext_person.g_elig_cvg_dfl_flg := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
617: ben_ext_person.g_elig_cvg_seq_no := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
618: ben_ext_person.g_elig_cvg_onl_flg := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
619: ben_ext_person.g_elig_cvg_calc_mthd := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
620: ben_ext_person.g_elig_cvg_bnft_typ := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
621: ben_ext_person.g_elig_cvg_bnft_uom := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
622: ben_ext_person.g_elig_pl_ord_no := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
623: ben_ext_person.g_elig_opt_ord_no := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
624: ben_ext_person.g_elig_pl_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
625: ben_ext_person.g_elig_pl_typ_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
626: ben_ext_person.g_elig_opt_id := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
627: ben_ext_person.g_elig_min_amt := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
628: ben_ext_person.g_elig_max_amt := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
629: ben_ext_person.g_elig_incr_amt := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
630: ben_ext_person.g_elig_dflt_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
631: ben_ext_person.g_elig_elec_made_dt := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
632: ben_ext_person.g_elig_program_id := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
633: ben_ext_person.g_elig_program_name := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
634: ben_ext_person.g_elig_er_ttl_cost := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
635: ben_ext_person.g_elig_ee_ttl_cost := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
636: ben_ext_person.g_elig_ee_after_tax_cost := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
637: ben_ext_person.g_elig_ee_pre_tax_cost := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
638: ben_ext_person.g_elig_total_premium_amt := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
639: ben_ext_person.g_elig_total_premium_uom := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
640: ben_ext_person.g_elig_rpt_group_name := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
641: ben_ext_person.g_elig_rpt_group_id := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
642: ben_ext_person.g_elig_pl_yr_strdt := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
643: ben_ext_person.g_elig_pl_yr_enddt := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
644: ben_ext_person.g_elig_pl_seq_num := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
645: ben_ext_person.g_elig_pip_seq_num := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
646: ben_ext_person.g_elig_ptp_seq_num := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
647: ben_ext_person.g_elig_oip_seq_num := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
648: ben_ext_person.g_elig_flex_01 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
649: ben_ext_person.g_elig_flex_02 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
650: ben_ext_person.g_elig_flex_03 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
651: ben_ext_person.g_elig_flex_04 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
652: ben_ext_person.g_elig_flex_05 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
653: ben_ext_person.g_elig_flex_06 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
654: ben_ext_person.g_elig_flex_07 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
655: ben_ext_person.g_elig_flex_08 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
656: ben_ext_person.g_elig_flex_09 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
657: ben_ext_person.g_elig_flex_10 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
658: ben_ext_person.g_elig_plan_flex_01 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
659: ben_ext_person.g_elig_plan_flex_02 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
660: ben_ext_person.g_elig_plan_flex_03 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
661: ben_ext_person.g_elig_plan_flex_04 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
662: ben_ext_person.g_elig_plan_flex_05 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
663: ben_ext_person.g_elig_plan_flex_06 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
664: ben_ext_person.g_elig_plan_flex_07 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
665: ben_ext_person.g_elig_plan_flex_08 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
666: ben_ext_person.g_elig_plan_flex_09 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
667: ben_ext_person.g_elig_plan_flex_10 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
668: ben_ext_person.g_elig_pgm_flex_01 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
669: ben_ext_person.g_elig_pgm_flex_02 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
670: ben_ext_person.g_elig_pgm_flex_03 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
671: ben_ext_person.g_elig_pgm_flex_04 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
672: ben_ext_person.g_elig_pgm_flex_05 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
673: ben_ext_person.g_elig_pgm_flex_06 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
674: ben_ext_person.g_elig_pgm_flex_07 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
675: ben_ext_person.g_elig_pgm_flex_08 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
676: ben_ext_person.g_elig_pgm_flex_09 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
677: ben_ext_person.g_elig_pgm_flex_10 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
678: ben_ext_person.g_elig_ptp_flex_01 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
679: ben_ext_person.g_elig_ptp_flex_02 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
680: ben_ext_person.g_elig_ptp_flex_03 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
681: ben_ext_person.g_elig_ptp_flex_04 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
682: ben_ext_person.g_elig_ptp_flex_05 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
683: ben_ext_person.g_elig_ptp_flex_06 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
684: ben_ext_person.g_elig_ptp_flex_07 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
685: ben_ext_person.g_elig_ptp_flex_08 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
686: ben_ext_person.g_elig_ptp_flex_09 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
687: ben_ext_person.g_elig_ptp_flex_10 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
688: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
689: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
690: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
691: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
692: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
693: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
694: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
695: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
696: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
697: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
698: ben_ext_person.g_elig_opt_in_pl_flex_01 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
699: ben_ext_person.g_elig_opt_in_pl_flex_02 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
700: ben_ext_person.g_elig_opt_in_pl_flex_03 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
701: ben_ext_person.g_elig_opt_in_pl_flex_04 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
702: ben_ext_person.g_elig_opt_in_pl_flex_05 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
703: ben_ext_person.g_elig_opt_in_pl_flex_06 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
704: ben_ext_person.g_elig_opt_in_pl_flex_07 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
705: ben_ext_person.g_elig_opt_in_pl_flex_08 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
706: ben_ext_person.g_elig_opt_in_pl_flex_09 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
707: ben_ext_person.g_elig_opt_in_pl_flex_10 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
708: ben_ext_person.g_elig_opt_flex_01 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
709: ben_ext_person.g_elig_opt_flex_02 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
710: ben_ext_person.g_elig_opt_flex_03 := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
711: ben_ext_person.g_elig_opt_flex_04 := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
712: ben_ext_person.g_elig_opt_flex_05 := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
713: ben_ext_person.g_elig_opt_flex_06 := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
714: ben_ext_person.g_elig_opt_flex_07 := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
715: ben_ext_person.g_elig_opt_flex_08 := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
716: ben_ext_person.g_elig_opt_flex_09 := null;
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
717: ben_ext_person.g_elig_opt_flex_10 := null;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
718: ben_ext_person.g_elig_ler_id := null;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
719: ben_ext_person.g_elig_lfevt_name := null;
720: ben_ext_person.g_elig_lfevt_status := null;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
721: ben_ext_person.g_elig_lfevt_note_dt := null;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
722: ben_ext_person.g_elig_lfevt_ocrd_dt := null;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
723: ben_ext_person.g_elig_per_elctbl_chc_id := null;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
724: ----2559743
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
725: ben_ext_person.g_elig_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
726: ben_ext_person.g_elig_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
727: ben_ext_person.g_elig_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
728: ben_ext_person.g_elig_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
729: ben_ext_person.g_elig_opt_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
730: ben_ext_person.g_elig_opt_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
731: ben_ext_person.g_elig_pl_typ_fd_name := null ;
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
732: ben_ext_person.g_elig_pl_typ_fd_code := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
733: ben_ext_person.g_elig_opt_pl_fd_name := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
734: ben_ext_person.g_elig_opt_pl_fd_code := null ;
735: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
736: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
737: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
738: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
739: ---cwb 2832419
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
740: ben_ext_person.g_elig_ee_cwb_dst_bdgt := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
741: ben_ext_person.g_elig_ee_cwb_misc_rate_1 := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
742: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
743: ben_ext_person.g_elig_ee_cwb_misc_rate_2 := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
744: ben_ext_person.g_elig_ee_cwb_grant_price := null ;
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
745: ben_ext_person.g_elig_ee_cwb_other_salary := null ;
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
753: --cobra letter
746: ben_ext_person.g_elig_ee_cwb_reserve := null ;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
747: ben_ext_person.g_elig_ee_cwb_recomond_amt := null ;
748: ben_ext_person.g_elig_ee_cwb_stated_salary := null ;
749: ben_ext_person.g_elig_ee_cwb_tot_compensation := null ;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
750: ben_ext_person.g_elig_ee_cwb_worksheet_bdgt := null ;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
751: ben_ext_person.g_elig_ee_cwb_elig_salary := null ;
752:
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
752:
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
753: --cobra letter
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
754: ben_ext_person.g_elig_cobra_payment_dys := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
755: ben_ext_person.g_elig_cobra_admin_name := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
756: ben_ext_person.g_elig_cobra_admin_org_name:= null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
757: ben_ext_person.g_elig_cobra_admin_addr1 := null;
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
765:
758: ben_ext_person.g_elig_cobra_admin_addr2 := null;
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
765:
766: --
759: ben_ext_person.g_elig_cobra_admin_addr3 := null;
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
765:
766: --
767: hr_utility.set_location('Exiting'||l_proc, 15);
760: ben_ext_person.g_elig_cobra_admin_city := null;
761: ben_ext_person.g_elig_cobra_admin_state := null;
762: ben_ext_person.g_elig_cobra_admin_country := null;
763: ben_ext_person.g_elig_cobra_admin_zip := null;
764: ben_ext_person.g_elig_cobra_admin_phone := null;
765:
766: --
767: hr_utility.set_location('Exiting'||l_proc, 15);
768: --
779: Begin
780: --
781: hr_utility.set_location('Entering'||l_proc, 5);
782: --
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
780: --
781: hr_utility.set_location('Entering'||l_proc, 5);
782: --
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
781: hr_utility.set_location('Entering'||l_proc, 5);
782: --
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
782: --
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
783: ben_ext_person.g_elig_age_val := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
784: ben_ext_person.g_elig_los_val := null;
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
792: --
785: ben_ext_person.g_elig_age_uom := null;
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
792: --
793: --
786: ben_ext_person.g_elig_los_uom := null;
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
792: --
793: --
794: hr_utility.set_location('Exiting'||l_proc, 15);
787: ben_ext_person.g_elig_comp_amt := null;
788: ben_ext_person.g_elig_comp_amt_uom := null;
789: ben_ext_person.g_elig_cmbn_age_n_los := null;
790: ben_ext_person.g_elig_hrs_wkd := null;
791: ben_ext_person.g_elig_pct_fl_tm := null;
792: --
793: --
794: hr_utility.set_location('Exiting'||l_proc, 15);
795: --
1472:
1473: -- we need to get option id for inclusion validation
1474: -- fusion try to cache the plan setup information
1475: -- intialize the variable
1476: ben_ext_person.g_elig_opt_id := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1473: -- we need to get option id for inclusion validation
1474: -- fusion try to cache the plan setup information
1475: -- intialize the variable
1476: ben_ext_person.g_elig_opt_id := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1474: -- fusion try to cache the plan setup information
1475: -- intialize the variable
1476: ben_ext_person.g_elig_opt_id := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1475: -- intialize the variable
1476: ben_ext_person.g_elig_opt_id := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1476: ben_ext_person.g_elig_opt_id := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1477: ben_ext_person.g_elig_opt_pl_fd_name := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1478: ben_ext_person.g_elig_opt_pl_fd_code := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1479: ben_ext_person.g_elig_opt_ord_no := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1480: ben_ext_person.g_elig_opt_in_pl_flex_01 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1481: ben_ext_person.g_elig_opt_in_pl_flex_02 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1489: ben_ext_person.g_elig_opt_in_pl_flex_10 := null ;
1482: ben_ext_person.g_elig_opt_in_pl_flex_03 := null ;
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1489: ben_ext_person.g_elig_opt_in_pl_flex_10 := null ;
1490:
1483: ben_ext_person.g_elig_opt_in_pl_flex_04 := null ;
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1489: ben_ext_person.g_elig_opt_in_pl_flex_10 := null ;
1490:
1491: if l_elig_oipl_id_va(i) is not null then
1484: ben_ext_person.g_elig_opt_in_pl_flex_05 := null ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1489: ben_ext_person.g_elig_opt_in_pl_flex_10 := null ;
1490:
1491: if l_elig_oipl_id_va(i) is not null then
1492: open c_oipl(l_elig_oipl_id_va(i), p_effective_date) ;
1485: ben_ext_person.g_elig_opt_in_pl_flex_06 := null ;
1486: ben_ext_person.g_elig_opt_in_pl_flex_07 := null ;
1487: ben_ext_person.g_elig_opt_in_pl_flex_08 := null ;
1488: ben_ext_person.g_elig_opt_in_pl_flex_09 := null ;
1489: ben_ext_person.g_elig_opt_in_pl_flex_10 := null ;
1490:
1491: if l_elig_oipl_id_va(i) is not null then
1492: open c_oipl(l_elig_oipl_id_va(i), p_effective_date) ;
1493: fetch c_oipl into
1490:
1491: if l_elig_oipl_id_va(i) is not null then
1492: open c_oipl(l_elig_oipl_id_va(i), p_effective_date) ;
1493: fetch c_oipl into
1494: ben_ext_person.g_elig_opt_id ,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1491: if l_elig_oipl_id_va(i) is not null then
1492: open c_oipl(l_elig_oipl_id_va(i), p_effective_date) ;
1493: fetch c_oipl into
1494: ben_ext_person.g_elig_opt_id ,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1492: open c_oipl(l_elig_oipl_id_va(i), p_effective_date) ;
1493: fetch c_oipl into
1494: ben_ext_person.g_elig_opt_id ,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1493: fetch c_oipl into
1494: ben_ext_person.g_elig_opt_id ,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1494: ben_ext_person.g_elig_opt_id ,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1495: ben_ext_person.g_elig_opt_pl_fd_name ,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1496: ben_ext_person.g_elig_opt_pl_fd_code ,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1497: ben_ext_person.g_elig_opt_ord_no ,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1498: ben_ext_person.g_elig_opt_in_pl_flex_01,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1499: ben_ext_person.g_elig_opt_in_pl_flex_02,
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1507: ben_ext_person.g_elig_opt_in_pl_flex_10
1500: ben_ext_person.g_elig_opt_in_pl_flex_03,
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1507: ben_ext_person.g_elig_opt_in_pl_flex_10
1508: ;
1501: ben_ext_person.g_elig_opt_in_pl_flex_04,
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1507: ben_ext_person.g_elig_opt_in_pl_flex_10
1508: ;
1509: close c_oipl ;
1502: ben_ext_person.g_elig_opt_in_pl_flex_05,
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1507: ben_ext_person.g_elig_opt_in_pl_flex_10
1508: ;
1509: close c_oipl ;
1510: end if ;
1503: ben_ext_person.g_elig_opt_in_pl_flex_06,
1504: ben_ext_person.g_elig_opt_in_pl_flex_07,
1505: ben_ext_person.g_elig_opt_in_pl_flex_08,
1506: ben_ext_person.g_elig_opt_in_pl_flex_09,
1507: ben_ext_person.g_elig_opt_in_pl_flex_10
1508: ;
1509: close c_oipl ;
1510: end if ;
1511:
1516: p_elct_enrt_strt_dt => l_elig_enrt_cvg_strt_dt_va(i),
1517: p_elct_yrprd_id => l_elig_yr_perd_id_va(i),
1518: p_elct_pgm_id => l_elig_program_id_va(i),
1519: p_elct_pl_typ_id => l_elig_pl_typ_id_va(i),
1520: p_elct_opt_id => ben_ext_person.g_elig_opt_id ,
1521: p_elct_last_upd_dt => l_elig_last_update_date_va(i),
1522: p_elct_per_in_ler_id => l_elig_per_in_ler_id_va(i),
1523: p_elct_ler_id => l_elig_ler_id_va(i),
1524: p_elct_per_in_ler_stat_cd => l_elig_per_in_ler_stat_cd_va(i),
1532: IF l_include = 'Y' THEN
1533: -- assign eligibility info to global variables
1534: --
1535: --- get plan setup information
1536: ben_ext_person.g_elig_pl_name := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1533: -- assign eligibility info to global variables
1534: --
1535: --- get plan setup information
1536: ben_ext_person.g_elig_pl_name := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1534: --
1535: --- get plan setup information
1536: ben_ext_person.g_elig_pl_name := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1535: --- get plan setup information
1536: ben_ext_person.g_elig_pl_name := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1536: ben_ext_person.g_elig_pl_name := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1537: ben_ext_person.g_elig_pl_fd_name := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1538: ben_ext_person.g_elig_pl_fd_code := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1539: ben_ext_person.g_elig_plan_flex_01 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1540: ben_ext_person.g_elig_plan_flex_02 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1541: ben_ext_person.g_elig_plan_flex_03 := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1549: ben_ext_person.g_elig_cobra_payment_dys := null ;
1542: ben_ext_person.g_elig_plan_flex_04 := null ;
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1549: ben_ext_person.g_elig_cobra_payment_dys := null ;
1550:
1543: ben_ext_person.g_elig_plan_flex_05 := null ;
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1549: ben_ext_person.g_elig_cobra_payment_dys := null ;
1550:
1551:
1544: ben_ext_person.g_elig_plan_flex_06 := null ;
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1549: ben_ext_person.g_elig_cobra_payment_dys := null ;
1550:
1551:
1552: if l_elig_pl_id_va(i) is not null then
1545: ben_ext_person.g_elig_plan_flex_07 := null ;
1546: ben_ext_person.g_elig_plan_flex_08 := null ;
1547: ben_ext_person.g_elig_plan_flex_09 := null ;
1548: ben_ext_person.g_elig_plan_flex_10 := null ;
1549: ben_ext_person.g_elig_cobra_payment_dys := null ;
1550:
1551:
1552: if l_elig_pl_id_va(i) is not null then
1553: open c_pl(l_elig_pl_id_va(i),p_effective_date) ;
1551:
1552: if l_elig_pl_id_va(i) is not null then
1553: open c_pl(l_elig_pl_id_va(i),p_effective_date) ;
1554: fetch c_pl into
1555: ben_ext_person.g_elig_pl_name ,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1552: if l_elig_pl_id_va(i) is not null then
1553: open c_pl(l_elig_pl_id_va(i),p_effective_date) ;
1554: fetch c_pl into
1555: ben_ext_person.g_elig_pl_name ,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1553: open c_pl(l_elig_pl_id_va(i),p_effective_date) ;
1554: fetch c_pl into
1555: ben_ext_person.g_elig_pl_name ,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1554: fetch c_pl into
1555: ben_ext_person.g_elig_pl_name ,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1555: ben_ext_person.g_elig_pl_name ,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1556: ben_ext_person.g_elig_pl_fd_name ,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1557: ben_ext_person.g_elig_pl_fd_code ,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1558: ben_ext_person.g_elig_plan_flex_01,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1559: ben_ext_person.g_elig_plan_flex_02,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1560: ben_ext_person.g_elig_plan_flex_03,
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1568: ben_ext_person.g_elig_cobra_payment_dys
1561: ben_ext_person.g_elig_plan_flex_04,
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1568: ben_ext_person.g_elig_cobra_payment_dys
1569: ;
1562: ben_ext_person.g_elig_plan_flex_05,
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1568: ben_ext_person.g_elig_cobra_payment_dys
1569: ;
1570: close c_pl ;
1563: ben_ext_person.g_elig_plan_flex_06,
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1568: ben_ext_person.g_elig_cobra_payment_dys
1569: ;
1570: close c_pl ;
1571: end if ;
1564: ben_ext_person.g_elig_plan_flex_07,
1565: ben_ext_person.g_elig_plan_flex_08,
1566: ben_ext_person.g_elig_plan_flex_09,
1567: ben_ext_person.g_elig_plan_flex_10,
1568: ben_ext_person.g_elig_cobra_payment_dys
1569: ;
1570: close c_pl ;
1571: end if ;
1572:
1569: ;
1570: close c_pl ;
1571: end if ;
1572:
1573: ben_ext_person.g_elig_opt_name := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1570: close c_pl ;
1571: end if ;
1572:
1573: ben_ext_person.g_elig_opt_name := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1571: end if ;
1572:
1573: ben_ext_person.g_elig_opt_name := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1572:
1573: ben_ext_person.g_elig_opt_name := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1573: ben_ext_person.g_elig_opt_name := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1574: ben_ext_person.g_elig_opt_fd_name := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1575: ben_ext_person.g_elig_opt_fd_code := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1576: ben_ext_person.g_elig_opt_flex_01 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1577: ben_ext_person.g_elig_opt_flex_02 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1578: ben_ext_person.g_elig_opt_flex_03 := null;
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1579: ben_ext_person.g_elig_opt_flex_04 := null;
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1580: ben_ext_person.g_elig_opt_flex_05 := null;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1581: ben_ext_person.g_elig_opt_flex_06 := null;
1582: ben_ext_person.g_elig_opt_flex_07 := null;
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1583: ben_ext_person.g_elig_opt_flex_08 := null;
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1584: ben_ext_person.g_elig_opt_flex_09 := null;
1585: ben_ext_person.g_elig_opt_flex_10 := null;
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1586:
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1587: if ben_ext_person.g_elig_opt_id is not null then
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1588: open c_opt (ben_ext_person.g_elig_opt_id,p_effective_date) ;
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1589: fetch c_opt into
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1590: ben_ext_person.g_elig_opt_name ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1591: ben_ext_person.g_elig_opt_fd_name ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1592: ben_ext_person.g_elig_opt_fd_code ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1593: ben_ext_person.g_elig_opt_flex_01 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1594: ben_ext_person.g_elig_opt_flex_02 ,
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1602: ben_ext_person.g_elig_opt_flex_10
1595: ben_ext_person.g_elig_opt_flex_03 ,
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1602: ben_ext_person.g_elig_opt_flex_10
1603: ;
1596: ben_ext_person.g_elig_opt_flex_04 ,
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1602: ben_ext_person.g_elig_opt_flex_10
1603: ;
1604: close c_opt ;
1597: ben_ext_person.g_elig_opt_flex_05 ,
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1602: ben_ext_person.g_elig_opt_flex_10
1603: ;
1604: close c_opt ;
1605: end if ;
1598: ben_ext_person.g_elig_opt_flex_06 ,
1599: ben_ext_person.g_elig_opt_flex_07 ,
1600: ben_ext_person.g_elig_opt_flex_08 ,
1601: ben_ext_person.g_elig_opt_flex_09 ,
1602: ben_ext_person.g_elig_opt_flex_10
1603: ;
1604: close c_opt ;
1605: end if ;
1606:
1603: ;
1604: close c_opt ;
1605: end if ;
1606:
1607: ben_ext_person.g_elig_program_name := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1604: close c_opt ;
1605: end if ;
1606:
1607: ben_ext_person.g_elig_program_name := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1605: end if ;
1606:
1607: ben_ext_person.g_elig_program_name := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1606:
1607: ben_ext_person.g_elig_program_name := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1607: ben_ext_person.g_elig_program_name := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1608: ben_ext_person.g_elig_pgm_fd_name := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1609: ben_ext_person.g_elig_pgm_fd_code := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1610: ben_ext_person.g_elig_pgm_flex_01 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1611: ben_ext_person.g_elig_pgm_flex_02 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1619: ben_ext_person.g_elig_pgm_flex_10 := null ;
1612: ben_ext_person.g_elig_pgm_flex_03 := null ;
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1619: ben_ext_person.g_elig_pgm_flex_10 := null ;
1620:
1613: ben_ext_person.g_elig_pgm_flex_04 := null ;
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1619: ben_ext_person.g_elig_pgm_flex_10 := null ;
1620:
1621:
1614: ben_ext_person.g_elig_pgm_flex_05 := null ;
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1619: ben_ext_person.g_elig_pgm_flex_10 := null ;
1620:
1621:
1622: if l_elig_program_id_va(i) is not null then
1615: ben_ext_person.g_elig_pgm_flex_06 := null ;
1616: ben_ext_person.g_elig_pgm_flex_07 := null ;
1617: ben_ext_person.g_elig_pgm_flex_08 := null ;
1618: ben_ext_person.g_elig_pgm_flex_09 := null ;
1619: ben_ext_person.g_elig_pgm_flex_10 := null ;
1620:
1621:
1622: if l_elig_program_id_va(i) is not null then
1623: open c_pgm_info (l_elig_program_id_va(i),p_effective_date) ;
1621:
1622: if l_elig_program_id_va(i) is not null then
1623: open c_pgm_info (l_elig_program_id_va(i),p_effective_date) ;
1624: fetch c_pgm_info into
1625: ben_ext_person.g_elig_program_name ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1622: if l_elig_program_id_va(i) is not null then
1623: open c_pgm_info (l_elig_program_id_va(i),p_effective_date) ;
1624: fetch c_pgm_info into
1625: ben_ext_person.g_elig_program_name ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1623: open c_pgm_info (l_elig_program_id_va(i),p_effective_date) ;
1624: fetch c_pgm_info into
1625: ben_ext_person.g_elig_program_name ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1624: fetch c_pgm_info into
1625: ben_ext_person.g_elig_program_name ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1625: ben_ext_person.g_elig_program_name ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1626: ben_ext_person.g_elig_pgm_fd_name ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1627: ben_ext_person.g_elig_pgm_fd_code ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1628: ben_ext_person.g_elig_pgm_flex_01 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1629: ben_ext_person.g_elig_pgm_flex_02 ,
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1637: ben_ext_person.g_elig_pgm_flex_10
1630: ben_ext_person.g_elig_pgm_flex_03 ,
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1637: ben_ext_person.g_elig_pgm_flex_10
1638: ;
1631: ben_ext_person.g_elig_pgm_flex_04 ,
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1637: ben_ext_person.g_elig_pgm_flex_10
1638: ;
1639: close c_pgm_info ;
1632: ben_ext_person.g_elig_pgm_flex_05 ,
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1637: ben_ext_person.g_elig_pgm_flex_10
1638: ;
1639: close c_pgm_info ;
1640: end if ;
1633: ben_ext_person.g_elig_pgm_flex_06 ,
1634: ben_ext_person.g_elig_pgm_flex_07 ,
1635: ben_ext_person.g_elig_pgm_flex_08 ,
1636: ben_ext_person.g_elig_pgm_flex_09 ,
1637: ben_ext_person.g_elig_pgm_flex_10
1638: ;
1639: close c_pgm_info ;
1640: end if ;
1641:
1638: ;
1639: close c_pgm_info ;
1640: end if ;
1641:
1642: ben_ext_person.g_elig_pl_typ_name := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1639: close c_pgm_info ;
1640: end if ;
1641:
1642: ben_ext_person.g_elig_pl_typ_name := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1640: end if ;
1641:
1642: ben_ext_person.g_elig_pl_typ_name := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1641:
1642: ben_ext_person.g_elig_pl_typ_name := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1642: ben_ext_person.g_elig_pl_typ_name := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1643: ben_ext_person.g_elig_pl_typ_fd_name := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1644: ben_ext_person.g_elig_pl_typ_fd_code := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1645: ben_ext_person.g_elig_ptp_flex_01 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1646: ben_ext_person.g_elig_ptp_flex_02 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1654: ben_ext_person.g_elig_ptp_flex_10 := null ;
1647: ben_ext_person.g_elig_ptp_flex_03 := null ;
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1654: ben_ext_person.g_elig_ptp_flex_10 := null ;
1655:
1648: ben_ext_person.g_elig_ptp_flex_04 := null ;
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1654: ben_ext_person.g_elig_ptp_flex_10 := null ;
1655:
1656:
1649: ben_ext_person.g_elig_ptp_flex_05 := null ;
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1654: ben_ext_person.g_elig_ptp_flex_10 := null ;
1655:
1656:
1657: if l_elig_pl_typ_id_va(i) is not null then
1650: ben_ext_person.g_elig_ptp_flex_06 := null ;
1651: ben_ext_person.g_elig_ptp_flex_07 := null ;
1652: ben_ext_person.g_elig_ptp_flex_08 := null ;
1653: ben_ext_person.g_elig_ptp_flex_09 := null ;
1654: ben_ext_person.g_elig_ptp_flex_10 := null ;
1655:
1656:
1657: if l_elig_pl_typ_id_va(i) is not null then
1658: open c_ptp (l_elig_pl_typ_id_va(i),p_effective_date) ;
1656:
1657: if l_elig_pl_typ_id_va(i) is not null then
1658: open c_ptp (l_elig_pl_typ_id_va(i),p_effective_date) ;
1659: fetch c_ptp into
1660: ben_ext_person.g_elig_pl_typ_name ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1657: if l_elig_pl_typ_id_va(i) is not null then
1658: open c_ptp (l_elig_pl_typ_id_va(i),p_effective_date) ;
1659: fetch c_ptp into
1660: ben_ext_person.g_elig_pl_typ_name ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1658: open c_ptp (l_elig_pl_typ_id_va(i),p_effective_date) ;
1659: fetch c_ptp into
1660: ben_ext_person.g_elig_pl_typ_name ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1659: fetch c_ptp into
1660: ben_ext_person.g_elig_pl_typ_name ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1660: ben_ext_person.g_elig_pl_typ_name ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1661: ben_ext_person.g_elig_pl_typ_fd_name ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1662: ben_ext_person.g_elig_pl_typ_fd_code ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1663: ben_ext_person.g_elig_ptp_flex_01 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1664: ben_ext_person.g_elig_ptp_flex_02 ,
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1672: ben_ext_person.g_elig_ptp_flex_10
1665: ben_ext_person.g_elig_ptp_flex_03 ,
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1672: ben_ext_person.g_elig_ptp_flex_10
1673: ;
1666: ben_ext_person.g_elig_ptp_flex_04 ,
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1672: ben_ext_person.g_elig_ptp_flex_10
1673: ;
1674: close c_ptp ;
1667: ben_ext_person.g_elig_ptp_flex_05 ,
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1672: ben_ext_person.g_elig_ptp_flex_10
1673: ;
1674: close c_ptp ;
1675: end if ;
1668: ben_ext_person.g_elig_ptp_flex_06 ,
1669: ben_ext_person.g_elig_ptp_flex_07 ,
1670: ben_ext_person.g_elig_ptp_flex_08 ,
1671: ben_ext_person.g_elig_ptp_flex_09 ,
1672: ben_ext_person.g_elig_ptp_flex_10
1673: ;
1674: close c_ptp ;
1675: end if ;
1676:
1673: ;
1674: close c_ptp ;
1675: end if ;
1676:
1677: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1674: close c_ptp ;
1675: end if ;
1676:
1677: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1675: end if ;
1676:
1677: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1676:
1677: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1677: ben_ext_person.g_elig_pl_pgm_fd_name := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1678: ben_ext_person.g_elig_pl_pgm_fd_code := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1679: ben_ext_person.g_elig_pl_ord_no := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1680: ben_ext_person.g_elig_pl_in_pgm_flex_01 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1681: ben_ext_person.g_elig_pl_in_pgm_flex_02 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1689: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null ;
1682: ben_ext_person.g_elig_pl_in_pgm_flex_03 := null ;
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1689: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null ;
1690:
1683: ben_ext_person.g_elig_pl_in_pgm_flex_04 := null ;
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1689: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null ;
1690:
1691:
1684: ben_ext_person.g_elig_pl_in_pgm_flex_05 := null ;
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1689: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null ;
1690:
1691:
1692:
1685: ben_ext_person.g_elig_pl_in_pgm_flex_06 := null ;
1686: ben_ext_person.g_elig_pl_in_pgm_flex_07 := null ;
1687: ben_ext_person.g_elig_pl_in_pgm_flex_08 := null ;
1688: ben_ext_person.g_elig_pl_in_pgm_flex_09 := null ;
1689: ben_ext_person.g_elig_pl_in_pgm_flex_10 := null ;
1690:
1691:
1692:
1693: if l_elig_plip_id_va(i) is not null then
1692:
1693: if l_elig_plip_id_va(i) is not null then
1694: open c_plip (l_elig_plip_id_va(i),p_effective_date) ;
1695: fetch c_plip into
1696: ben_ext_person.g_elig_pl_pgm_fd_name ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1693: if l_elig_plip_id_va(i) is not null then
1694: open c_plip (l_elig_plip_id_va(i),p_effective_date) ;
1695: fetch c_plip into
1696: ben_ext_person.g_elig_pl_pgm_fd_name ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1694: open c_plip (l_elig_plip_id_va(i),p_effective_date) ;
1695: fetch c_plip into
1696: ben_ext_person.g_elig_pl_pgm_fd_name ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1695: fetch c_plip into
1696: ben_ext_person.g_elig_pl_pgm_fd_name ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1696: ben_ext_person.g_elig_pl_pgm_fd_name ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1697: ben_ext_person.g_elig_pl_pgm_fd_code ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1698: ben_ext_person.g_elig_pl_ord_no ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1699: ben_ext_person.g_elig_pl_in_pgm_flex_01 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1700: ben_ext_person.g_elig_pl_in_pgm_flex_02 ,
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1708: ben_ext_person.g_elig_pl_in_pgm_flex_10
1701: ben_ext_person.g_elig_pl_in_pgm_flex_03 ,
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1708: ben_ext_person.g_elig_pl_in_pgm_flex_10
1709: ;
1702: ben_ext_person.g_elig_pl_in_pgm_flex_04 ,
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1708: ben_ext_person.g_elig_pl_in_pgm_flex_10
1709: ;
1710:
1703: ben_ext_person.g_elig_pl_in_pgm_flex_05 ,
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1708: ben_ext_person.g_elig_pl_in_pgm_flex_10
1709: ;
1710:
1711: close c_plip ;
1704: ben_ext_person.g_elig_pl_in_pgm_flex_06 ,
1705: ben_ext_person.g_elig_pl_in_pgm_flex_07 ,
1706: ben_ext_person.g_elig_pl_in_pgm_flex_08 ,
1707: ben_ext_person.g_elig_pl_in_pgm_flex_09 ,
1708: ben_ext_person.g_elig_pl_in_pgm_flex_10
1709: ;
1710:
1711: close c_plip ;
1712: end if ;
1712: end if ;
1713:
1714:
1715:
1716: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
1717: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
1718:
1719: if l_elig_ptip_id_va(i) is not null then
1720: open c_ptip (l_elig_ptip_id_va(i),p_effective_date) ;
1713:
1714:
1715:
1716: ben_ext_person.g_elig_pl_typ_pgm_fd_name := null ;
1717: ben_ext_person.g_elig_pl_typ_pgm_fd_code := null ;
1718:
1719: if l_elig_ptip_id_va(i) is not null then
1720: open c_ptip (l_elig_ptip_id_va(i),p_effective_date) ;
1721: fetch c_ptip into
1718:
1719: if l_elig_ptip_id_va(i) is not null then
1720: open c_ptip (l_elig_ptip_id_va(i),p_effective_date) ;
1721: fetch c_ptip into
1722: ben_ext_person.g_elig_pl_typ_pgm_fd_name ,
1723: ben_ext_person.g_elig_pl_typ_pgm_fd_code
1724: ;
1725: close c_ptip ;
1726: end if ;
1719: if l_elig_ptip_id_va(i) is not null then
1720: open c_ptip (l_elig_ptip_id_va(i),p_effective_date) ;
1721: fetch c_ptip into
1722: ben_ext_person.g_elig_pl_typ_pgm_fd_name ,
1723: ben_ext_person.g_elig_pl_typ_pgm_fd_code
1724: ;
1725: close c_ptip ;
1726: end if ;
1727:
1726: end if ;
1727:
1728:
1729:
1730: ben_ext_person.g_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1727:
1728:
1729:
1730: ben_ext_person.g_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1728:
1729:
1730: ben_ext_person.g_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1729:
1730: ben_ext_person.g_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1730: ben_ext_person.g_elig_per_elctbl_chc_id := l_elig_per_elctbl_chc_id_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1731: ben_ext_person.g_elig_cvg_amt := l_elig_cvg_amt_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1732: ben_ext_person.g_elig_cvg_min_amt := l_elig_mn_val_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1733: ben_ext_person.g_elig_cvg_max_amt := l_elig_mx_val_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1734: ben_ext_person.g_elig_cvg_inc_amt := l_elig_incrmt_val_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1735: ben_ext_person.g_elig_cvg_dfl_amt := l_elig_dflt_val_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1736: ben_ext_person.g_elig_cvg_dfl_flg := l_elig_dflt_flag_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1737: ben_ext_person.g_elig_cvg_seq_no := l_elig_ordr_num_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1738: ben_ext_person.g_elig_cvg_onl_flg := l_elig_entr_val_at_flag_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1739: ben_ext_person.g_elig_cvg_calc_mthd := l_elig_cvg_mlt_cd_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1740: ben_ext_person.g_elig_cvg_bnft_typ := l_elig_bnft_typ_cd_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1741: ben_ext_person.g_elig_cvg_bnft_uom := l_elig_nnmntry_uom_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1742: ben_ext_person.g_elig_enrt_strt_dt := l_elig_enrt_strt_dt_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1743: ben_ext_person.g_elig_enrt_end_dt := l_elig_enrt_end_dt_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1744: ben_ext_person.g_elig_dflt_enrt_dt := l_elig_dflt_enrt_dt_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1745: ben_ext_person.g_elig_uom := l_elig_uom_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1746: ben_ext_person.g_elig_pl_id := l_elig_pl_id_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1747: ben_ext_person.g_elig_pl_typ_id := l_elig_pl_typ_id_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1748: ben_ext_person.g_elig_elec_made_dt := l_elig_elcn_made_dt_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1749: ben_ext_person.g_elig_program_id := l_elig_program_id_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1750: ben_ext_person.g_elig_pl_seq_num := l_elig_pl_seq_num_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1751: ben_ext_person.g_elig_pip_seq_num := l_elig_plip_seq_num_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1752: ben_ext_person.g_elig_ptp_seq_num := l_elig_ptip_seq_num_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1753: ben_ext_person.g_elig_oip_seq_num := l_elig_oipl_seq_num_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1754: ben_ext_person.g_elig_flex_01 := l_elig_flex_01_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1755: ben_ext_person.g_elig_flex_02 := l_elig_flex_02_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1763: ben_ext_person.g_elig_flex_10 := l_elig_flex_10_va(i);
1756: ben_ext_person.g_elig_flex_03 := l_elig_flex_03_va(i);
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1763: ben_ext_person.g_elig_flex_10 := l_elig_flex_10_va(i);
1764: --
1757: ben_ext_person.g_elig_flex_04 := l_elig_flex_04_va(i);
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1763: ben_ext_person.g_elig_flex_10 := l_elig_flex_10_va(i);
1764: --
1765: --
1758: ben_ext_person.g_elig_flex_05 := l_elig_flex_05_va(i);
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1763: ben_ext_person.g_elig_flex_10 := l_elig_flex_10_va(i);
1764: --
1765: --
1766: init_detl_drvd_fctr_globals;
1759: ben_ext_person.g_elig_flex_06 := l_elig_flex_06_va(i);
1760: ben_ext_person.g_elig_flex_07 := l_elig_flex_07_va(i);
1761: ben_ext_person.g_elig_flex_08 := l_elig_flex_08_va(i);
1762: ben_ext_person.g_elig_flex_09 := l_elig_flex_09_va(i);
1763: ben_ext_person.g_elig_flex_10 := l_elig_flex_10_va(i);
1764: --
1765: --
1766: init_detl_drvd_fctr_globals;
1767: --
1767: --
1768: open c_pl_elig(l_elig_pl_id_va(i) ,l_elig_ler_id_va(i) ,l_elig_person_id_va(i));
1769: --
1770: fetch c_pl_elig into l_pl_id,
1771: ben_ext_person.g_elig_age_val,
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1768: open c_pl_elig(l_elig_pl_id_va(i) ,l_elig_ler_id_va(i) ,l_elig_person_id_va(i));
1769: --
1770: fetch c_pl_elig into l_pl_id,
1771: ben_ext_person.g_elig_age_val,
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1769: --
1770: fetch c_pl_elig into l_pl_id,
1771: ben_ext_person.g_elig_age_val,
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1770: fetch c_pl_elig into l_pl_id,
1771: ben_ext_person.g_elig_age_val,
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1771: ben_ext_person.g_elig_age_val,
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1779: ben_ext_person.g_elig_pct_fl_tm;
1772: ben_ext_person.g_elig_age_uom,
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1779: ben_ext_person.g_elig_pct_fl_tm;
1780: --
1773: ben_ext_person.g_elig_los_val,
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1779: ben_ext_person.g_elig_pct_fl_tm;
1780: --
1781: if c_pl_elig%notfound then
1774: ben_ext_person.g_elig_los_uom,
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1779: ben_ext_person.g_elig_pct_fl_tm;
1780: --
1781: if c_pl_elig%notfound then
1782: --
1775: ben_ext_person.g_elig_comp_amt,
1776: ben_ext_person.g_elig_comp_amt_uom,
1777: ben_ext_person.g_elig_cmbn_age_n_los,
1778: ben_ext_person.g_elig_hrs_wkd,
1779: ben_ext_person.g_elig_pct_fl_tm;
1780: --
1781: if c_pl_elig%notfound then
1782: --
1783: open c_pgm(l_elig_pl_id_va(i) ,l_elig_ler_id_va(i) ,l_elig_person_id_va(i));
1782: --
1783: open c_pgm(l_elig_pl_id_va(i) ,l_elig_ler_id_va(i) ,l_elig_person_id_va(i));
1784: --
1785: fetch c_pgm into l_pl_id,
1786: ben_ext_person.g_elig_age_val,
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1783: open c_pgm(l_elig_pl_id_va(i) ,l_elig_ler_id_va(i) ,l_elig_person_id_va(i));
1784: --
1785: fetch c_pgm into l_pl_id,
1786: ben_ext_person.g_elig_age_val,
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1784: --
1785: fetch c_pgm into l_pl_id,
1786: ben_ext_person.g_elig_age_val,
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1785: fetch c_pgm into l_pl_id,
1786: ben_ext_person.g_elig_age_val,
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1786: ben_ext_person.g_elig_age_val,
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1794: ben_ext_person.g_elig_pct_fl_tm;
1787: ben_ext_person.g_elig_age_uom,
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1794: ben_ext_person.g_elig_pct_fl_tm;
1795: --
1788: ben_ext_person.g_elig_los_val,
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1794: ben_ext_person.g_elig_pct_fl_tm;
1795: --
1796: close c_pgm;
1789: ben_ext_person.g_elig_los_uom ,
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1794: ben_ext_person.g_elig_pct_fl_tm;
1795: --
1796: close c_pgm;
1797: --
1790: ben_ext_person.g_elig_comp_amt,
1791: ben_ext_person.g_elig_comp_amt_uom,
1792: ben_ext_person.g_elig_cmbn_age_n_los,
1793: ben_ext_person.g_elig_hrs_wkd,
1794: ben_ext_person.g_elig_pct_fl_tm;
1795: --
1796: close c_pgm;
1797: --
1798: end if;
1813: if ben_extract.g_eprem_csr = 'Y' then
1814: --
1815: open c_prem_tot(l_elig_per_elctbl_chc_id_va(i));
1816: --
1817: fetch c_prem_tot into ben_ext_person.g_elig_total_premium_amt
1818: , ben_ext_person.g_elig_total_premium_uom;
1819: --
1820: close c_prem_tot;
1821: --
1814: --
1815: open c_prem_tot(l_elig_per_elctbl_chc_id_va(i));
1816: --
1817: fetch c_prem_tot into ben_ext_person.g_elig_total_premium_amt
1818: , ben_ext_person.g_elig_total_premium_uom;
1819: --
1820: close c_prem_tot;
1821: --
1822: end if;
1827: if ben_extract.g_ergrp_csr = 'Y' then
1828: --
1829: open c_rpt_grp(l_elig_per_elctbl_chc_id_va(i));
1830: --
1831: fetch c_rpt_grp into ben_ext_person.g_elig_rpt_group_id,
1832: ben_ext_person.g_elig_rpt_group_name;
1833: --
1834: close c_rpt_grp;
1835: --
1828: --
1829: open c_rpt_grp(l_elig_per_elctbl_chc_id_va(i));
1830: --
1831: fetch c_rpt_grp into ben_ext_person.g_elig_rpt_group_id,
1832: ben_ext_person.g_elig_rpt_group_name;
1833: --
1834: close c_rpt_grp;
1835: --
1836: end if;
1841: if ben_extract.g_eplyr_csr = 'Y' then
1842: --
1843: open c_pl_yr(l_elig_per_elctbl_chc_id_va(i));
1844: --
1845: fetch c_pl_yr into ben_ext_person.g_elig_pl_yr_strdt,
1846: ben_ext_person.g_elig_pl_yr_enddt;
1847: --
1848: close c_pl_yr;
1849: --
1842: --
1843: open c_pl_yr(l_elig_per_elctbl_chc_id_va(i));
1844: --
1845: fetch c_pl_yr into ben_ext_person.g_elig_pl_yr_strdt,
1846: ben_ext_person.g_elig_pl_yr_enddt;
1847: --
1848: close c_pl_yr;
1849: --
1850: end if;
1854: if ben_extract.g_eler_csr = 'Y' then
1855: --
1856: open c_ler(l_elig_per_in_ler_id_va(i)) ;
1857: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,
1859: ben_ext_person.g_elig_lfevt_name,
1860: ben_ext_person.g_elig_lfevt_status,
1861: ben_ext_person.g_elig_lfevt_note_dt,
1862: ben_ext_person.g_elig_lfevt_ocrd_dt;
1855: --
1856: open c_ler(l_elig_per_in_ler_id_va(i)) ;
1857: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,
1859: ben_ext_person.g_elig_lfevt_name,
1860: ben_ext_person.g_elig_lfevt_status,
1861: ben_ext_person.g_elig_lfevt_note_dt,
1862: ben_ext_person.g_elig_lfevt_ocrd_dt;
1863: --
1856: open c_ler(l_elig_per_in_ler_id_va(i)) ;
1857: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,
1859: ben_ext_person.g_elig_lfevt_name,
1860: ben_ext_person.g_elig_lfevt_status,
1861: ben_ext_person.g_elig_lfevt_note_dt,
1862: ben_ext_person.g_elig_lfevt_ocrd_dt;
1863: --
1864: close c_ler;
1857: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,
1859: ben_ext_person.g_elig_lfevt_name,
1860: ben_ext_person.g_elig_lfevt_status,
1861: ben_ext_person.g_elig_lfevt_note_dt,
1862: ben_ext_person.g_elig_lfevt_ocrd_dt;
1863: --
1864: close c_ler;
1865: --
1858: fetch c_ler into ben_ext_person.g_elig_ler_id,
1859: ben_ext_person.g_elig_lfevt_name,
1860: ben_ext_person.g_elig_lfevt_status,
1861: ben_ext_person.g_elig_lfevt_note_dt,
1862: ben_ext_person.g_elig_lfevt_ocrd_dt;
1863: --
1864: close c_ler;
1865: --
1866: end if;
1871: if ben_Extract.g_cbradm_csr = 'Y' then
1872:
1873: hr_utility.set_location('getting cobra admin ' ,160);
1874: open c_cbradm_pl(l_elig_pl_id_va(i));
1875: fetch c_cbradm_pl into ben_ext_person.g_elig_cobra_admin_name ,
1876: l_organization_id ;
1877: if c_cbradm_pl%notfound then
1878: open c_cbradm_pgm(l_elig_program_id_va(i));
1879: fetch c_cbradm_pgm into ben_ext_person.g_elig_cobra_admin_name ,
1875: fetch c_cbradm_pl into ben_ext_person.g_elig_cobra_admin_name ,
1876: l_organization_id ;
1877: if c_cbradm_pl%notfound then
1878: open c_cbradm_pgm(l_elig_program_id_va(i));
1879: fetch c_cbradm_pgm into ben_ext_person.g_elig_cobra_admin_name ,
1880: l_organization_id ;
1881: close c_cbradm_pgm ;
1882: end if ;
1883: close c_cbradm_pl ;
1880: l_organization_id ;
1881: close c_cbradm_pgm ;
1882: end if ;
1883: close c_cbradm_pl ;
1884: hr_utility.set_location(' cobra admin ' || ben_ext_person.g_elig_cobra_admin_name ,160);
1885: --- cobra admin address
1886: if l_organization_id is not null then
1887:
1888: hr_utility.set_location('getting cobra admin address ' ,160);
1887:
1888: hr_utility.set_location('getting cobra admin address ' ,160);
1889: open c_cbradm_adr(l_organization_id ) ;
1890: fetch c_cbradm_adr into
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1888: hr_utility.set_location('getting cobra admin address ' ,160);
1889: open c_cbradm_adr(l_organization_id ) ;
1890: fetch c_cbradm_adr into
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1889: open c_cbradm_adr(l_organization_id ) ;
1890: fetch c_cbradm_adr into
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1890: fetch c_cbradm_adr into
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1891: ben_ext_person.g_elig_cobra_admin_org_name
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1892: ,ben_ext_person.g_elig_cobra_admin_addr1
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1893: ,ben_ext_person.g_elig_cobra_admin_addr2
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1894: ,ben_ext_person.g_elig_cobra_admin_addr3
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1895: ,ben_ext_person.g_elig_cobra_admin_city
1896: ,ben_ext_person.g_elig_cobra_admin_state
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1903: end if ;
1897: ,ben_ext_person.g_elig_cobra_admin_zip
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1903: end if ;
1904: end if ;
1905: -- cobra end
1898: ,ben_ext_person.g_elig_cobra_admin_country
1899: ,ben_ext_person.g_elig_cobra_admin_phone;
1900: close c_cbradm_adr ;
1901: hr_utility.set_location(' cobra org admin ' || ben_ext_person.g_elig_cobra_admin_org_name ,160);
1902: hr_utility.set_location(' cobra org city ' || ben_ext_person.g_elig_cobra_admin_city ,160);
1903: end if ;
1904: end if ;
1905: -- cobra end
1906: