eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PLAN_DESIGN_ELPRO_MODULE dependencies on BEN_PLAN_DESIGN_PROGRAM_MODULE

Line 461: open ben_plan_design_program_module.g_table_route('EPA');

457: --
458: for l_epa_rec in c_epa(l_prtn_elig_id,l_mirror_src_entity_result_id,'EPA' ) loop
459: --
460: l_table_route_id := null ;
461: open ben_plan_design_program_module.g_table_route('EPA');
462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
463: close ben_plan_design_program_module.g_table_route ;
464: --
465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||

Line 462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

458: for l_epa_rec in c_epa(l_prtn_elig_id,l_mirror_src_entity_result_id,'EPA' ) loop
459: --
460: l_table_route_id := null ;
461: open ben_plan_design_program_module.g_table_route('EPA');
462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
463: close ben_plan_design_program_module.g_table_route ;
464: --
465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||
466: hr_general.decode_lookup('BEN_PRTN_ELIG_END',l_epa_rec.prtn_eff_end_dt_cd);

Line 463: close ben_plan_design_program_module.g_table_route ;

459: --
460: l_table_route_id := null ;
461: open ben_plan_design_program_module.g_table_route('EPA');
462: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
463: close ben_plan_design_program_module.g_table_route ;
464: --
465: l_information5 := hr_general.decode_lookup('BEN_PRTN_ELIG_STRT',l_epa_rec.prtn_eff_strt_dt_cd)||' '||
466: hr_general.decode_lookup('BEN_PRTN_ELIG_END',l_epa_rec.prtn_eff_end_dt_cd);
467: --'Intersection';

Line 562: ben_plan_design_program_module.create_formula_result(

558: l_out_epa_result_id := l_copy_entity_result_id ;
559: end if;
560: --
561: if (l_epa_rec.mx_poe_det_dt_rl is not null) then
562: ben_plan_design_program_module.create_formula_result(
563: p_validate => p_validate
564: ,p_copy_entity_result_id => l_copy_entity_result_id
565: ,p_copy_entity_txn_id => p_copy_entity_txn_id
566: ,p_formula_id => l_epa_rec.mx_poe_det_dt_rl

Line 574: ben_plan_design_program_module.create_formula_result(

570: ,p_effective_date => p_effective_date);
571: end if;
572:
573: if (l_epa_rec.mx_poe_rl is not null) then
574: ben_plan_design_program_module.create_formula_result(
575: p_validate => p_validate
576: ,p_copy_entity_result_id => l_copy_entity_result_id
577: ,p_copy_entity_txn_id => p_copy_entity_txn_id
578: ,p_formula_id => l_epa_rec.mx_poe_rl

Line 586: ben_plan_design_program_module.create_formula_result(

582: ,p_effective_date => p_effective_date);
583: end if;
584:
585: if (l_epa_rec.prtn_eff_end_dt_rl is not null) then
586: ben_plan_design_program_module.create_formula_result(
587: p_validate => p_validate
588: ,p_copy_entity_result_id => l_copy_entity_result_id
589: ,p_copy_entity_txn_id => p_copy_entity_txn_id
590: ,p_formula_id => l_epa_rec.prtn_eff_end_dt_rl

Line 598: ben_plan_design_program_module.create_formula_result(

594: ,p_effective_date => p_effective_date);
595: end if;
596:
597: if (l_epa_rec.prtn_eff_strt_dt_rl is not null) then
598: ben_plan_design_program_module.create_formula_result(
599: p_validate => p_validate
600: ,p_copy_entity_result_id => l_copy_entity_result_id
601: ,p_copy_entity_txn_id => p_copy_entity_txn_id
602: ,p_formula_id => l_epa_rec.prtn_eff_strt_dt_rl

Line 610: ben_plan_design_program_module.create_formula_result(

606: ,p_effective_date => p_effective_date);
607: end if;
608:
609: if (l_epa_rec.wait_perd_dt_to_use_rl is not null) then
610: ben_plan_design_program_module.create_formula_result(
611: p_validate => p_validate
612: ,p_copy_entity_result_id => l_copy_entity_result_id
613: ,p_copy_entity_txn_id => p_copy_entity_txn_id
614: ,p_formula_id => l_epa_rec.wait_perd_dt_to_use_rl

Line 622: ben_plan_design_program_module.create_formula_result(

618: ,p_effective_date => p_effective_date);
619: end if;
620:
621: if (l_epa_rec.wait_perd_rl is not null) then
622: ben_plan_design_program_module.create_formula_result(
623: p_validate => p_validate
624: ,p_copy_entity_result_id => l_copy_entity_result_id
625: ,p_copy_entity_txn_id => p_copy_entity_txn_id
626: ,p_formula_id => l_epa_rec.wait_perd_rl

Line 648: open ben_plan_design_program_module.g_table_route('CEP');

644: --
645: for l_cep_rec in c_cep(l_parent_rec.prtn_elig_prfl_id,l_mirror_src_entity_result_id, 'CEP' ) loop
646: --
647: l_table_route_id := null ;
648: open ben_plan_design_program_module.g_table_route('CEP');
649: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
650: close ben_plan_design_program_module.g_table_route ;
651: --
652: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_cep_rec.eligy_prfl_id

Line 649: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

645: for l_cep_rec in c_cep(l_parent_rec.prtn_elig_prfl_id,l_mirror_src_entity_result_id, 'CEP' ) loop
646: --
647: l_table_route_id := null ;
648: open ben_plan_design_program_module.g_table_route('CEP');
649: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
650: close ben_plan_design_program_module.g_table_route ;
651: --
652: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_cep_rec.eligy_prfl_id
653: ,p_effective_date); --'Intersection';

Line 650: close ben_plan_design_program_module.g_table_route ;

646: --
647: l_table_route_id := null ;
648: open ben_plan_design_program_module.g_table_route('CEP');
649: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
650: close ben_plan_design_program_module.g_table_route ;
651: --
652: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_cep_rec.eligy_prfl_id
653: ,p_effective_date); --'Intersection';
654: --

Line 652: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_cep_rec.eligy_prfl_id

648: open ben_plan_design_program_module.g_table_route('CEP');
649: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
650: close ben_plan_design_program_module.g_table_route ;
651: --
652: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_cep_rec.eligy_prfl_id
653: ,p_effective_date); --'Intersection';
654: --
655: if p_effective_date between l_cep_rec.effective_start_date
656: and l_cep_rec.effective_end_date then

Line 744: l_mirror_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_allow_dup_rslt;

740: --
741: end loop;
742: --
743:
744: l_mirror_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_allow_dup_rslt;
745: -- Create Eligibility Profiles and Criteria
746:
747: -- Bug 5059695
748: if(ben_plan_design_elpro_module.g_trasaction_category = 'PQHGSP') then

Line 751: l_dummy_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

747: -- Bug 5059695
748: if(ben_plan_design_elpro_module.g_trasaction_category = 'PQHGSP') then
749: l_dummy_g_pdw_allow_dup_rslt := null;
750: else
751: l_dummy_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
752: end if;
753: -- End Bug 5059695
754:
755: for l_parent_rec in c_elp_from_parent(l_PRTN_ELIG_PRFL_ID) loop

Line 775: ben_plan_design_program_module.g_pdw_allow_dup_rslt := l_mirror_g_pdw_allow_dup_rslt;

771: --Passed the value PDW_NO_DUP_RSLT to create_elig_prfl_results so that
772: --no duplicate results are created
773: end loop;
774:
775: ben_plan_design_program_module.g_pdw_allow_dup_rslt := l_mirror_g_pdw_allow_dup_rslt;
776: -- ENH Avoid duplicates in Eligibility Profiles
777: --reset the global allow dup results to as it was before
778:
779: end loop;

Line 796: open ben_plan_design_program_module.g_table_route('CER');

792: --
793: for l_cer_rec in c_cer(l_parent_rec.prtn_eligy_rl_id,l_mirror_src_entity_result_id,'CER' ) loop
794: --
795: l_table_route_id := null ;
796: open ben_plan_design_program_module.g_table_route('CER');
797: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
798: close ben_plan_design_program_module.g_table_route ;
799: --
800: l_information5 := ben_plan_design_program_module.get_formula_name(l_cer_rec.formula_id

Line 797: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

793: for l_cer_rec in c_cer(l_parent_rec.prtn_eligy_rl_id,l_mirror_src_entity_result_id,'CER' ) loop
794: --
795: l_table_route_id := null ;
796: open ben_plan_design_program_module.g_table_route('CER');
797: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
798: close ben_plan_design_program_module.g_table_route ;
799: --
800: l_information5 := ben_plan_design_program_module.get_formula_name(l_cer_rec.formula_id
801: ,p_effective_date); --'Intersection';

Line 798: close ben_plan_design_program_module.g_table_route ;

794: --
795: l_table_route_id := null ;
796: open ben_plan_design_program_module.g_table_route('CER');
797: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
798: close ben_plan_design_program_module.g_table_route ;
799: --
800: l_information5 := ben_plan_design_program_module.get_formula_name(l_cer_rec.formula_id
801: ,p_effective_date); --'Intersection';
802: --

Line 800: l_information5 := ben_plan_design_program_module.get_formula_name(l_cer_rec.formula_id

796: open ben_plan_design_program_module.g_table_route('CER');
797: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
798: close ben_plan_design_program_module.g_table_route ;
799: --
800: l_information5 := ben_plan_design_program_module.get_formula_name(l_cer_rec.formula_id
801: ,p_effective_date); --'Intersection';
802: --
803: if p_effective_date between l_cer_rec.effective_start_date
804: and l_cer_rec.effective_end_date then

Line 881: ben_plan_design_program_module.create_formula_result(

877: l_out_cer_result_id := l_copy_entity_result_id ;
878: end if;
879: --
880: if (l_cer_rec.formula_id is not null) then
881: ben_plan_design_program_module.create_formula_result(
882: p_validate => p_validate
883: ,p_copy_entity_result_id => l_copy_entity_result_id
884: ,p_copy_entity_txn_id => p_copy_entity_txn_id
885: ,p_formula_id => l_cer_rec.formula_id

Line 1017: open ben_plan_design_program_module.g_table_route('ADE');

1013: --
1014: for l_ade_rec in c_ade(l_parent_rec.apld_dpnt_cvg_elig_prfl_id,l_mirror_src_entity_result_id,'ADE' ) loop
1015: --
1016: l_table_route_id := null ;
1017: open ben_plan_design_program_module.g_table_route('ADE');
1018: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1019: close ben_plan_design_program_module.g_table_route ;
1020: --
1021: l_information5 := ben_plan_design_program_module.get_dpnt_cvg_eligy_prfl_name

Line 1018: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

1014: for l_ade_rec in c_ade(l_parent_rec.apld_dpnt_cvg_elig_prfl_id,l_mirror_src_entity_result_id,'ADE' ) loop
1015: --
1016: l_table_route_id := null ;
1017: open ben_plan_design_program_module.g_table_route('ADE');
1018: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1019: close ben_plan_design_program_module.g_table_route ;
1020: --
1021: l_information5 := ben_plan_design_program_module.get_dpnt_cvg_eligy_prfl_name
1022: (l_ade_rec.dpnt_cvg_eligy_prfl_id

Line 1019: close ben_plan_design_program_module.g_table_route ;

1015: --
1016: l_table_route_id := null ;
1017: open ben_plan_design_program_module.g_table_route('ADE');
1018: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1019: close ben_plan_design_program_module.g_table_route ;
1020: --
1021: l_information5 := ben_plan_design_program_module.get_dpnt_cvg_eligy_prfl_name
1022: (l_ade_rec.dpnt_cvg_eligy_prfl_id
1023: ,p_effective_date); --'Intersection';

Line 1021: l_information5 := ben_plan_design_program_module.get_dpnt_cvg_eligy_prfl_name

1017: open ben_plan_design_program_module.g_table_route('ADE');
1018: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1019: close ben_plan_design_program_module.g_table_route ;
1020: --
1021: l_information5 := ben_plan_design_program_module.get_dpnt_cvg_eligy_prfl_name
1022: (l_ade_rec.dpnt_cvg_eligy_prfl_id
1023: ,p_effective_date); --'Intersection';
1024: --
1025: if p_effective_date between l_ade_rec.effective_start_date

Line 1104: ben_plan_design_program_module.create_formula_result(

1100: l_out_ade_result_id := l_copy_entity_result_id ;
1101: end if;
1102: --
1103: if (l_ade_rec.apld_dpnt_cvg_elig_rl is not null) then
1104: ben_plan_design_program_module.create_formula_result(
1105: p_validate => p_validate
1106: ,p_copy_entity_result_id => l_copy_entity_result_id
1107: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1108: ,p_formula_id => l_ade_rec.apld_dpnt_cvg_elig_rl

Line 3946: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

3942:
3943: end if;
3944: --End Bug 5059695
3945:
3946: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3947: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
3948: end if;
3949:
3950: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 3947: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

3943: end if;
3944: --End Bug 5059695
3945:
3946: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3947: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
3948: end if;
3949:
3950: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3951: open c_object_exists(p_eligy_prfl_id,'ELP');

Line 3950: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

3946: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3947: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
3948: end if;
3949:
3950: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
3951: open c_object_exists(p_eligy_prfl_id,'ELP');
3952: fetch c_object_exists into l_dummy;
3953: if c_object_exists%found then
3954: close c_object_exists;

Line 3969: open ben_plan_design_program_module.g_table_route('ELP');

3965: --
3966: for l_elp_rec in c_elp(p_eligy_prfl_id,l_mirror_src_entity_result_id,'ELP' ) loop
3967: --
3968: l_table_route_id := null ;
3969: open ben_plan_design_program_module.g_table_route('ELP');
3970: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3971: close ben_plan_design_program_module.g_table_route ;
3972: --
3973: l_information5 := l_elp_rec.name; --'Intersection';

Line 3970: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

3966: for l_elp_rec in c_elp(p_eligy_prfl_id,l_mirror_src_entity_result_id,'ELP' ) loop
3967: --
3968: l_table_route_id := null ;
3969: open ben_plan_design_program_module.g_table_route('ELP');
3970: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3971: close ben_plan_design_program_module.g_table_route ;
3972: --
3973: l_information5 := l_elp_rec.name; --'Intersection';
3974: --

Line 3971: close ben_plan_design_program_module.g_table_route ;

3967: --
3968: l_table_route_id := null ;
3969: open ben_plan_design_program_module.g_table_route('ELP');
3970: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3971: close ben_plan_design_program_module.g_table_route ;
3972: --
3973: l_information5 := l_elp_rec.name; --'Intersection';
3974: --
3975: -- Display the text (Required) if mndtry_flag = 'Y'

Line 4160: open ben_plan_design_program_module.g_table_route('CGP');

4156: --
4157: for l_cgp_rec in c_cgp(l_parent_rec.cntng_prtn_elig_prfl_id,l_mirror_src_entity_result_id,'CGP' ) loop
4158: --
4159: l_table_route_id := null ;
4160: open ben_plan_design_program_module.g_table_route('CGP');
4161: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4162: close ben_plan_design_program_module.g_table_route ;
4163: --
4164: l_information5 := l_cgp_rec.pymt_must_be_rcvd_num ||' '||

Line 4161: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4157: for l_cgp_rec in c_cgp(l_parent_rec.cntng_prtn_elig_prfl_id,l_mirror_src_entity_result_id,'CGP' ) loop
4158: --
4159: l_table_route_id := null ;
4160: open ben_plan_design_program_module.g_table_route('CGP');
4161: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4162: close ben_plan_design_program_module.g_table_route ;
4163: --
4164: l_information5 := l_cgp_rec.pymt_must_be_rcvd_num ||' '||
4165: hr_general.decode_lookup('BEN_TM_UOM', l_cgp_rec.pymt_must_be_rcvd_uom);

Line 4162: close ben_plan_design_program_module.g_table_route ;

4158: --
4159: l_table_route_id := null ;
4160: open ben_plan_design_program_module.g_table_route('CGP');
4161: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4162: close ben_plan_design_program_module.g_table_route ;
4163: --
4164: l_information5 := l_cgp_rec.pymt_must_be_rcvd_num ||' '||
4165: hr_general.decode_lookup('BEN_TM_UOM', l_cgp_rec.pymt_must_be_rcvd_uom);
4166: --'Intersection';

Line 4247: ben_plan_design_program_module.create_formula_result(

4243: end if;
4244: --
4245:
4246: if (l_cgp_rec.pymt_must_be_rcvd_rl is not null) then
4247: ben_plan_design_program_module.create_formula_result(
4248: p_validate => p_validate
4249: ,p_copy_entity_result_id => l_copy_entity_result_id
4250: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4251: ,p_formula_id => l_cgp_rec.pymt_must_be_rcvd_rl

Line 4279: open ben_plan_design_program_module.g_table_route('ERL');

4275: --
4276: for l_erl_rec in c_erl(l_parent_rec.eligy_prfl_rl_id,l_mirror_src_entity_result_id,'ERL' ) loop
4277: --
4278: l_table_route_id := null ;
4279: open ben_plan_design_program_module.g_table_route('ERL');
4280: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4281: close ben_plan_design_program_module.g_table_route ;
4282: --
4283: l_information5 := ben_plan_design_program_module.get_formula_name(l_erl_rec.formula_id

Line 4280: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4276: for l_erl_rec in c_erl(l_parent_rec.eligy_prfl_rl_id,l_mirror_src_entity_result_id,'ERL' ) loop
4277: --
4278: l_table_route_id := null ;
4279: open ben_plan_design_program_module.g_table_route('ERL');
4280: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4281: close ben_plan_design_program_module.g_table_route ;
4282: --
4283: l_information5 := ben_plan_design_program_module.get_formula_name(l_erl_rec.formula_id
4284: ,p_effective_date); --'Intersection';

Line 4281: close ben_plan_design_program_module.g_table_route ;

4277: --
4278: l_table_route_id := null ;
4279: open ben_plan_design_program_module.g_table_route('ERL');
4280: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4281: close ben_plan_design_program_module.g_table_route ;
4282: --
4283: l_information5 := ben_plan_design_program_module.get_formula_name(l_erl_rec.formula_id
4284: ,p_effective_date); --'Intersection';
4285: --

Line 4283: l_information5 := ben_plan_design_program_module.get_formula_name(l_erl_rec.formula_id

4279: open ben_plan_design_program_module.g_table_route('ERL');
4280: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4281: close ben_plan_design_program_module.g_table_route ;
4282: --
4283: l_information5 := ben_plan_design_program_module.get_formula_name(l_erl_rec.formula_id
4284: ,p_effective_date); --'Intersection';
4285: --
4286: if p_effective_date between l_erl_rec.effective_start_date
4287: and l_erl_rec.effective_end_date then

Line 4366: ben_plan_design_program_module.create_formula_result(

4362: l_out_erl_result_id := l_copy_entity_result_id ;
4363: end if;
4364: --
4365: if (l_erl_rec.formula_id is not null) then
4366: ben_plan_design_program_module.create_formula_result(
4367: p_validate => p_validate
4368: ,p_copy_entity_result_id => l_copy_entity_result_id
4369: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4370: ,p_formula_id => l_erl_rec.formula_id

Line 4396: open ben_plan_design_program_module.g_table_route('EAP');

4392: --
4393: for l_eap_rec in c_eap(l_parent_rec.elig_age_prte_id,l_mirror_src_entity_result_id,'EAP' ) loop
4394: --
4395: l_table_route_id := null ;
4396: open ben_plan_design_program_module.g_table_route('EAP');
4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4398: close ben_plan_design_program_module.g_table_route ;
4399: --
4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)

Line 4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4393: for l_eap_rec in c_eap(l_parent_rec.elig_age_prte_id,l_mirror_src_entity_result_id,'EAP' ) loop
4394: --
4395: l_table_route_id := null ;
4396: open ben_plan_design_program_module.g_table_route('EAP');
4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4398: close ben_plan_design_program_module.g_table_route ;
4399: --
4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)
4401: || ben_plan_design_program_module.get_exclude_message(l_eap_rec.excld_flag);

Line 4398: close ben_plan_design_program_module.g_table_route ;

4394: --
4395: l_table_route_id := null ;
4396: open ben_plan_design_program_module.g_table_route('EAP');
4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4398: close ben_plan_design_program_module.g_table_route ;
4399: --
4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)
4401: || ben_plan_design_program_module.get_exclude_message(l_eap_rec.excld_flag);
4402: --'Intersection';

Line 4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)

4396: open ben_plan_design_program_module.g_table_route('EAP');
4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4398: close ben_plan_design_program_module.g_table_route ;
4399: --
4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)
4401: || ben_plan_design_program_module.get_exclude_message(l_eap_rec.excld_flag);
4402: --'Intersection';
4403: --
4404: if p_effective_date between l_eap_rec.effective_start_date

Line 4401: || ben_plan_design_program_module.get_exclude_message(l_eap_rec.excld_flag);

4397: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4398: close ben_plan_design_program_module.g_table_route ;
4399: --
4400: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eap_rec.age_fctr_id)
4401: || ben_plan_design_program_module.get_exclude_message(l_eap_rec.excld_flag);
4402: --'Intersection';
4403: --
4404: if p_effective_date between l_eap_rec.effective_start_date
4405: and l_eap_rec.effective_end_date then

Line 4519: open ben_plan_design_program_module.g_table_route('EAN');

4515: --
4516: for l_ean_rec in c_ean(l_parent_rec.elig_asnt_set_prte_id,l_mirror_src_entity_result_id,'EAN' ) loop
4517: --
4518: l_table_route_id := null ;
4519: open ben_plan_design_program_module.g_table_route('EAN');
4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4521: close ben_plan_design_program_module.g_table_route ;
4522: --
4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)

Line 4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4516: for l_ean_rec in c_ean(l_parent_rec.elig_asnt_set_prte_id,l_mirror_src_entity_result_id,'EAN' ) loop
4517: --
4518: l_table_route_id := null ;
4519: open ben_plan_design_program_module.g_table_route('EAN');
4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4521: close ben_plan_design_program_module.g_table_route ;
4522: --
4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)
4524: || ben_plan_design_program_module.get_exclude_message(l_ean_rec.excld_flag);

Line 4521: close ben_plan_design_program_module.g_table_route ;

4517: --
4518: l_table_route_id := null ;
4519: open ben_plan_design_program_module.g_table_route('EAN');
4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4521: close ben_plan_design_program_module.g_table_route ;
4522: --
4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)
4524: || ben_plan_design_program_module.get_exclude_message(l_ean_rec.excld_flag);
4525: --'Intersection';

Line 4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)

4519: open ben_plan_design_program_module.g_table_route('EAN');
4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4521: close ben_plan_design_program_module.g_table_route ;
4522: --
4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)
4524: || ben_plan_design_program_module.get_exclude_message(l_ean_rec.excld_flag);
4525: --'Intersection';
4526: --
4527: if p_effective_date between l_ean_rec.effective_start_date

Line 4524: || ben_plan_design_program_module.get_exclude_message(l_ean_rec.excld_flag);

4520: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4521: close ben_plan_design_program_module.g_table_route ;
4522: --
4523: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_ean_rec.assignment_set_id)
4524: || ben_plan_design_program_module.get_exclude_message(l_ean_rec.excld_flag);
4525: --'Intersection';
4526: --
4527: if p_effective_date between l_ean_rec.effective_start_date
4528: and l_ean_rec.effective_end_date then

Line 4654: open ben_plan_design_program_module.g_table_route('EBN');

4650: --
4651: for l_ebn_rec in c_ebn(l_parent_rec.elig_benfts_grp_prte_id,l_mirror_src_entity_result_id,'EBN' ) loop
4652: --
4653: l_table_route_id := null ;
4654: open ben_plan_design_program_module.g_table_route('EBN');
4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4656: close ben_plan_design_program_module.g_table_route ;
4657: --
4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)

Line 4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4651: for l_ebn_rec in c_ebn(l_parent_rec.elig_benfts_grp_prte_id,l_mirror_src_entity_result_id,'EBN' ) loop
4652: --
4653: l_table_route_id := null ;
4654: open ben_plan_design_program_module.g_table_route('EBN');
4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4656: close ben_plan_design_program_module.g_table_route ;
4657: --
4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)
4659: || ben_plan_design_program_module.get_exclude_message(l_ebn_rec.excld_flag);

Line 4656: close ben_plan_design_program_module.g_table_route ;

4652: --
4653: l_table_route_id := null ;
4654: open ben_plan_design_program_module.g_table_route('EBN');
4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4656: close ben_plan_design_program_module.g_table_route ;
4657: --
4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)
4659: || ben_plan_design_program_module.get_exclude_message(l_ebn_rec.excld_flag);
4660: --'Intersection';

Line 4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)

4654: open ben_plan_design_program_module.g_table_route('EBN');
4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4656: close ben_plan_design_program_module.g_table_route ;
4657: --
4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)
4659: || ben_plan_design_program_module.get_exclude_message(l_ebn_rec.excld_flag);
4660: --'Intersection';
4661: --
4662: if p_effective_date between l_ebn_rec.effective_start_date

Line 4659: || ben_plan_design_program_module.get_exclude_message(l_ebn_rec.excld_flag);

4655: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4656: close ben_plan_design_program_module.g_table_route ;
4657: --
4658: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_ebn_rec.benfts_grp_id)
4659: || ben_plan_design_program_module.get_exclude_message(l_ebn_rec.excld_flag);
4660: --'Intersection';
4661: --
4662: if p_effective_date between l_ebn_rec.effective_start_date
4663: and l_ebn_rec.effective_end_date then

Line 4772: open ben_plan_design_program_module.g_table_route('EBU');

4768: --
4769: for l_ebu_rec in c_ebu(l_parent_rec.elig_brgng_unit_prte_id,l_mirror_src_entity_result_id,'EBU' ) loop
4770: --
4771: l_table_route_id := null ;
4772: open ben_plan_design_program_module.g_table_route('EBU');
4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4774: close ben_plan_design_program_module.g_table_route ;
4775: --
4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)

Line 4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4769: for l_ebu_rec in c_ebu(l_parent_rec.elig_brgng_unit_prte_id,l_mirror_src_entity_result_id,'EBU' ) loop
4770: --
4771: l_table_route_id := null ;
4772: open ben_plan_design_program_module.g_table_route('EBU');
4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4774: close ben_plan_design_program_module.g_table_route ;
4775: --
4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)
4777: || ben_plan_design_program_module.get_exclude_message(l_ebu_rec.excld_flag);

Line 4774: close ben_plan_design_program_module.g_table_route ;

4770: --
4771: l_table_route_id := null ;
4772: open ben_plan_design_program_module.g_table_route('EBU');
4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4774: close ben_plan_design_program_module.g_table_route ;
4775: --
4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)
4777: || ben_plan_design_program_module.get_exclude_message(l_ebu_rec.excld_flag);
4778: --'Intersection';

Line 4777: || ben_plan_design_program_module.get_exclude_message(l_ebu_rec.excld_flag);

4773: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4774: close ben_plan_design_program_module.g_table_route ;
4775: --
4776: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_ebu_rec.brgng_unit_cd)
4777: || ben_plan_design_program_module.get_exclude_message(l_ebu_rec.excld_flag);
4778: --'Intersection';
4779: --
4780: if p_effective_date between l_ebu_rec.effective_start_date
4781: and l_ebu_rec.effective_end_date then

Line 4877: open ben_plan_design_program_module.g_table_route('ECQ');

4873: --
4874: for l_ecq_rec in c_ecq(l_parent_rec.elig_cbr_quald_bnf_id,l_mirror_src_entity_result_id,'ECQ' ) loop
4875: --
4876: l_table_route_id := null ;
4877: open ben_plan_design_program_module.g_table_route('ECQ');
4878: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4879: close ben_plan_design_program_module.g_table_route ;
4880: --
4881: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_ecq_rec.ptip_id

Line 4878: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4874: for l_ecq_rec in c_ecq(l_parent_rec.elig_cbr_quald_bnf_id,l_mirror_src_entity_result_id,'ECQ' ) loop
4875: --
4876: l_table_route_id := null ;
4877: open ben_plan_design_program_module.g_table_route('ECQ');
4878: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4879: close ben_plan_design_program_module.g_table_route ;
4880: --
4881: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_ecq_rec.ptip_id
4882: ,l_ecq_rec.pgm_id

Line 4879: close ben_plan_design_program_module.g_table_route ;

4875: --
4876: l_table_route_id := null ;
4877: open ben_plan_design_program_module.g_table_route('ECQ');
4878: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4879: close ben_plan_design_program_module.g_table_route ;
4880: --
4881: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_ecq_rec.ptip_id
4882: ,l_ecq_rec.pgm_id
4883: ,p_effective_date)

Line 4881: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_ecq_rec.ptip_id

4877: open ben_plan_design_program_module.g_table_route('ECQ');
4878: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4879: close ben_plan_design_program_module.g_table_route ;
4880: --
4881: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_ecq_rec.ptip_id
4882: ,l_ecq_rec.pgm_id
4883: ,p_effective_date)
4884: --
4885: -- Bug no: 3451872

Line 4989: open ben_plan_design_program_module.g_table_route('ECP');

4985: --
4986: for l_ecp_rec in c_ecp(l_parent_rec.elig_cmbn_age_los_prte_id,l_mirror_src_entity_result_id,'ECP') loop
4987: --
4988: l_table_route_id := null ;
4989: open ben_plan_design_program_module.g_table_route('ECP');
4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4991: close ben_plan_design_program_module.g_table_route ;
4992: --
4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)

Line 4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

4986: for l_ecp_rec in c_ecp(l_parent_rec.elig_cmbn_age_los_prte_id,l_mirror_src_entity_result_id,'ECP') loop
4987: --
4988: l_table_route_id := null ;
4989: open ben_plan_design_program_module.g_table_route('ECP');
4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4991: close ben_plan_design_program_module.g_table_route ;
4992: --
4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)
4994: || ben_plan_design_program_module.get_exclude_message(l_ecp_rec.excld_flag);

Line 4991: close ben_plan_design_program_module.g_table_route ;

4987: --
4988: l_table_route_id := null ;
4989: open ben_plan_design_program_module.g_table_route('ECP');
4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4991: close ben_plan_design_program_module.g_table_route ;
4992: --
4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)
4994: || ben_plan_design_program_module.get_exclude_message(l_ecp_rec.excld_flag);
4995: --'Intersection';

Line 4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)

4989: open ben_plan_design_program_module.g_table_route('ECP');
4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4991: close ben_plan_design_program_module.g_table_route ;
4992: --
4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)
4994: || ben_plan_design_program_module.get_exclude_message(l_ecp_rec.excld_flag);
4995: --'Intersection';
4996: --
4997: if p_effective_date between l_ecp_rec.effective_start_date

Line 4994: || ben_plan_design_program_module.get_exclude_message(l_ecp_rec.excld_flag);

4990: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4991: close ben_plan_design_program_module.g_table_route ;
4992: --
4993: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_ecp_rec.cmbn_age_los_fctr_id)
4994: || ben_plan_design_program_module.get_exclude_message(l_ecp_rec.excld_flag);
4995: --'Intersection';
4996: --
4997: if p_effective_date between l_ecp_rec.effective_start_date
4998: and l_ecp_rec.effective_end_date then

Line 5113: open ben_plan_design_program_module.g_table_route('ECL');

5109: --
5110: for l_ecl_rec in c_ecl(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5111: --
5112: l_table_route_id := null ;
5113: open ben_plan_design_program_module.g_table_route('ECL');
5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5115: close ben_plan_design_program_module.g_table_route ;
5116: --
5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)

Line 5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5110: for l_ecl_rec in c_ecl(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5111: --
5112: l_table_route_id := null ;
5113: open ben_plan_design_program_module.g_table_route('ECL');
5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5115: close ben_plan_design_program_module.g_table_route ;
5116: --
5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)
5118: || ben_plan_design_program_module.get_exclude_message(l_ecl_rec.excld_flag);

Line 5115: close ben_plan_design_program_module.g_table_route ;

5111: --
5112: l_table_route_id := null ;
5113: open ben_plan_design_program_module.g_table_route('ECL');
5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5115: close ben_plan_design_program_module.g_table_route ;
5116: --
5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)
5118: || ben_plan_design_program_module.get_exclude_message(l_ecl_rec.excld_flag);
5119: --'Intersection';

Line 5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)

5113: open ben_plan_design_program_module.g_table_route('ECL');
5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5115: close ben_plan_design_program_module.g_table_route ;
5116: --
5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)
5118: || ben_plan_design_program_module.get_exclude_message(l_ecl_rec.excld_flag);
5119: --'Intersection';
5120: --
5121: if p_effective_date between l_ecl_rec.effective_start_date

Line 5118: || ben_plan_design_program_module.get_exclude_message(l_ecl_rec.excld_flag);

5114: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5115: close ben_plan_design_program_module.g_table_route ;
5116: --
5117: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_ecl_rec.comp_lvl_fctr_id)
5118: || ben_plan_design_program_module.get_exclude_message(l_ecl_rec.excld_flag);
5119: --'Intersection';
5120: --
5121: if p_effective_date between l_ecl_rec.effective_start_date
5122: and l_ecl_rec.effective_end_date then

Line 5239: open ben_plan_design_program_module.g_table_route('EDG');

5235: --
5236: for l_edg_rec in c_edg(l_parent_rec.elig_dpnt_cvrd_othr_pgm_id,l_mirror_src_entity_result_id,'EDG' ) loop
5237: --
5238: l_table_route_id := null ;
5239: open ben_plan_design_program_module.g_table_route('EDG');
5240: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5241: close ben_plan_design_program_module.g_table_route ;
5242: --
5243: l_information5 := ben_plan_design_program_module.get_pgm_name(l_edg_rec.pgm_id,p_effective_date)

Line 5240: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5236: for l_edg_rec in c_edg(l_parent_rec.elig_dpnt_cvrd_othr_pgm_id,l_mirror_src_entity_result_id,'EDG' ) loop
5237: --
5238: l_table_route_id := null ;
5239: open ben_plan_design_program_module.g_table_route('EDG');
5240: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5241: close ben_plan_design_program_module.g_table_route ;
5242: --
5243: l_information5 := ben_plan_design_program_module.get_pgm_name(l_edg_rec.pgm_id,p_effective_date)
5244: --

Line 5241: close ben_plan_design_program_module.g_table_route ;

5237: --
5238: l_table_route_id := null ;
5239: open ben_plan_design_program_module.g_table_route('EDG');
5240: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5241: close ben_plan_design_program_module.g_table_route ;
5242: --
5243: l_information5 := ben_plan_design_program_module.get_pgm_name(l_edg_rec.pgm_id,p_effective_date)
5244: --
5245: -- Bug No: 3451872

Line 5243: l_information5 := ben_plan_design_program_module.get_pgm_name(l_edg_rec.pgm_id,p_effective_date)

5239: open ben_plan_design_program_module.g_table_route('EDG');
5240: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5241: close ben_plan_design_program_module.g_table_route ;
5242: --
5243: l_information5 := ben_plan_design_program_module.get_pgm_name(l_edg_rec.pgm_id,p_effective_date)
5244: --
5245: -- Bug No: 3451872
5246: --
5247: || ' '

Line 5251: || ben_plan_design_program_module.get_exclude_message(l_edg_rec.excld_flag);

5247: || ' '
5248: || get_det_enrl_det_dt_name(l_edg_rec.ENRL_DET_DT_CD,'BEN_ENRL_DET_DT')
5249: || get_subj_to_cobra_message(l_edg_rec.ONLY_PLS_SUBJ_COBRA_FLAG)
5250: --
5251: || ben_plan_design_program_module.get_exclude_message(l_edg_rec.excld_flag);
5252: --'Intersection';
5253: --
5254: if p_effective_date between l_edg_rec.effective_start_date
5255: and l_edg_rec.effective_end_date then

Line 5347: open ben_plan_design_program_module.g_table_route('EDP');

5343: --
5344: for l_edp_rec in c_edp(l_parent_rec.elig_dpnt_cvrd_othr_pl_id,l_mirror_src_entity_result_id,'EDP') loop
5345: --
5346: l_table_route_id := null ;
5347: open ben_plan_design_program_module.g_table_route('EDP');
5348: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5349: close ben_plan_design_program_module.g_table_route ;
5350: --
5351: l_information5 := ben_plan_design_program_module.get_pl_name(l_edp_rec.pl_id,p_effective_date)

Line 5348: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5344: for l_edp_rec in c_edp(l_parent_rec.elig_dpnt_cvrd_othr_pl_id,l_mirror_src_entity_result_id,'EDP') loop
5345: --
5346: l_table_route_id := null ;
5347: open ben_plan_design_program_module.g_table_route('EDP');
5348: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5349: close ben_plan_design_program_module.g_table_route ;
5350: --
5351: l_information5 := ben_plan_design_program_module.get_pl_name(l_edp_rec.pl_id,p_effective_date)
5352: --

Line 5349: close ben_plan_design_program_module.g_table_route ;

5345: --
5346: l_table_route_id := null ;
5347: open ben_plan_design_program_module.g_table_route('EDP');
5348: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5349: close ben_plan_design_program_module.g_table_route ;
5350: --
5351: l_information5 := ben_plan_design_program_module.get_pl_name(l_edp_rec.pl_id,p_effective_date)
5352: --
5353: -- Bug No: 3451872

Line 5351: l_information5 := ben_plan_design_program_module.get_pl_name(l_edp_rec.pl_id,p_effective_date)

5347: open ben_plan_design_program_module.g_table_route('EDP');
5348: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5349: close ben_plan_design_program_module.g_table_route ;
5350: --
5351: l_information5 := ben_plan_design_program_module.get_pl_name(l_edp_rec.pl_id,p_effective_date)
5352: --
5353: -- Bug No: 3451872
5354: --
5355: || ' '

Line 5358: || ben_plan_design_program_module.get_exclude_message(l_edp_rec.excld_flag);

5354: --
5355: || ' '
5356: || get_det_enrl_det_dt_name(l_edp_rec.CVG_DET_DT_CD,'BEN_CVG_DET_DT')
5357: --
5358: || ben_plan_design_program_module.get_exclude_message(l_edp_rec.excld_flag);
5359: --'Intersection';
5360: --
5361: if p_effective_date between l_edp_rec.effective_start_date
5362: and l_edp_rec.effective_end_date then

Line 5453: open ben_plan_design_program_module.g_table_route('EDT');

5449: --
5450: for l_edt_rec in c_edt(l_parent_rec.elig_dpnt_cvrd_othr_ptip_id,l_mirror_src_entity_result_id,'EDT' ) loop
5451: --
5452: l_table_route_id := null ;
5453: open ben_plan_design_program_module.g_table_route('EDT');
5454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5455: close ben_plan_design_program_module.g_table_route ;
5456: --
5457: l_information5 := ben_plan_design_program_module.get_ptip_name(l_edt_rec.ptip_id,p_effective_date)

Line 5454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5450: for l_edt_rec in c_edt(l_parent_rec.elig_dpnt_cvrd_othr_ptip_id,l_mirror_src_entity_result_id,'EDT' ) loop
5451: --
5452: l_table_route_id := null ;
5453: open ben_plan_design_program_module.g_table_route('EDT');
5454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5455: close ben_plan_design_program_module.g_table_route ;
5456: --
5457: l_information5 := ben_plan_design_program_module.get_ptip_name(l_edt_rec.ptip_id,p_effective_date)
5458: --

Line 5455: close ben_plan_design_program_module.g_table_route ;

5451: --
5452: l_table_route_id := null ;
5453: open ben_plan_design_program_module.g_table_route('EDT');
5454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5455: close ben_plan_design_program_module.g_table_route ;
5456: --
5457: l_information5 := ben_plan_design_program_module.get_ptip_name(l_edt_rec.ptip_id,p_effective_date)
5458: --
5459: -- Bug No: 3451872

Line 5457: l_information5 := ben_plan_design_program_module.get_ptip_name(l_edt_rec.ptip_id,p_effective_date)

5453: open ben_plan_design_program_module.g_table_route('EDT');
5454: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5455: close ben_plan_design_program_module.g_table_route ;
5456: --
5457: l_information5 := ben_plan_design_program_module.get_ptip_name(l_edt_rec.ptip_id,p_effective_date)
5458: --
5459: -- Bug No: 3451872
5460: --
5461: || ' '

Line 5465: || ben_plan_design_program_module.get_exclude_message(l_edt_rec.excld_flag);

5461: || ' '
5462: || get_det_enrl_det_dt_name(l_edt_rec.ENRL_DET_DT_CD,'BEN_ENRL_DET_DT')
5463: || get_subj_to_cobra_message(l_edt_rec.ONLY_PLS_SUBJ_COBRA_FLAG)
5464: --
5465: || ben_plan_design_program_module.get_exclude_message(l_edt_rec.excld_flag);
5466: --'Intersection';
5467: --
5468: if p_effective_date between l_edt_rec.effective_start_date
5469: and l_edt_rec.effective_end_date then

Line 5561: open ben_plan_design_program_module.g_table_route('EDI');

5557: --
5558: for l_edi_rec in c_edi(l_parent_rec.elig_dpnt_cvrd_plip_id,l_mirror_src_entity_result_id,'EDI' ) loop
5559: --
5560: l_table_route_id := null ;
5561: open ben_plan_design_program_module.g_table_route('EDI');
5562: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5563: close ben_plan_design_program_module.g_table_route ;
5564: --
5565: l_information5 := ben_plan_design_program_module.get_plip_name(l_edi_rec.plip_id,p_effective_date)

Line 5562: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5558: for l_edi_rec in c_edi(l_parent_rec.elig_dpnt_cvrd_plip_id,l_mirror_src_entity_result_id,'EDI' ) loop
5559: --
5560: l_table_route_id := null ;
5561: open ben_plan_design_program_module.g_table_route('EDI');
5562: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5563: close ben_plan_design_program_module.g_table_route ;
5564: --
5565: l_information5 := ben_plan_design_program_module.get_plip_name(l_edi_rec.plip_id,p_effective_date)
5566: --

Line 5563: close ben_plan_design_program_module.g_table_route ;

5559: --
5560: l_table_route_id := null ;
5561: open ben_plan_design_program_module.g_table_route('EDI');
5562: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5563: close ben_plan_design_program_module.g_table_route ;
5564: --
5565: l_information5 := ben_plan_design_program_module.get_plip_name(l_edi_rec.plip_id,p_effective_date)
5566: --
5567: -- Bug No: 3451872

Line 5565: l_information5 := ben_plan_design_program_module.get_plip_name(l_edi_rec.plip_id,p_effective_date)

5561: open ben_plan_design_program_module.g_table_route('EDI');
5562: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5563: close ben_plan_design_program_module.g_table_route ;
5564: --
5565: l_information5 := ben_plan_design_program_module.get_plip_name(l_edi_rec.plip_id,p_effective_date)
5566: --
5567: -- Bug No: 3451872
5568: --
5569: || ' '

Line 5572: || ben_plan_design_program_module.get_exclude_message(l_edi_rec.excld_flag);

5568: --
5569: || ' '
5570: || get_det_enrl_det_dt_name(l_edi_rec.ENRL_DET_DT_CD,'BEN_ENRL_DET_DT')
5571: --
5572: || ben_plan_design_program_module.get_exclude_message(l_edi_rec.excld_flag);
5573: --'Intersection';
5574: --
5575: if p_effective_date between l_edi_rec.effective_start_date
5576: and l_edi_rec.effective_end_date then

Line 5667: open ben_plan_design_program_module.g_table_route('ETD');

5663: --
5664: for l_etd_rec in c_etd(l_parent_rec.elig_dpnt_othr_ptip_id,l_mirror_src_entity_result_id,'ETD' ) loop
5665: --
5666: l_table_route_id := null ;
5667: open ben_plan_design_program_module.g_table_route('ETD');
5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5669: close ben_plan_design_program_module.g_table_route ;
5670: --
5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)

Line 5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5664: for l_etd_rec in c_etd(l_parent_rec.elig_dpnt_othr_ptip_id,l_mirror_src_entity_result_id,'ETD' ) loop
5665: --
5666: l_table_route_id := null ;
5667: open ben_plan_design_program_module.g_table_route('ETD');
5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5669: close ben_plan_design_program_module.g_table_route ;
5670: --
5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)
5672: || ben_plan_design_program_module.get_exclude_message(l_etd_rec.excld_flag);

Line 5669: close ben_plan_design_program_module.g_table_route ;

5665: --
5666: l_table_route_id := null ;
5667: open ben_plan_design_program_module.g_table_route('ETD');
5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5669: close ben_plan_design_program_module.g_table_route ;
5670: --
5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)
5672: || ben_plan_design_program_module.get_exclude_message(l_etd_rec.excld_flag);
5673: --'Intersection';

Line 5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)

5667: open ben_plan_design_program_module.g_table_route('ETD');
5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5669: close ben_plan_design_program_module.g_table_route ;
5670: --
5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)
5672: || ben_plan_design_program_module.get_exclude_message(l_etd_rec.excld_flag);
5673: --'Intersection';
5674: --
5675: if p_effective_date between l_etd_rec.effective_start_date

Line 5672: || ben_plan_design_program_module.get_exclude_message(l_etd_rec.excld_flag);

5668: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5669: close ben_plan_design_program_module.g_table_route ;
5670: --
5671: l_information5 := ben_plan_design_program_module.get_ptip_name(l_etd_rec.ptip_id,p_effective_date)
5672: || ben_plan_design_program_module.get_exclude_message(l_etd_rec.excld_flag);
5673: --'Intersection';
5674: --
5675: if p_effective_date between l_etd_rec.effective_start_date
5676: and l_etd_rec.effective_end_date then

Line 5766: open ben_plan_design_program_module.g_table_route('EDS');

5762: --
5763: for l_eds_rec in c_eds(l_parent_rec.elig_dsbld_stat_prte_id,l_mirror_src_entity_result_id,'EDS') loop
5764: --
5765: l_table_route_id := null ;
5766: open ben_plan_design_program_module.g_table_route('EDS');
5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5768: close ben_plan_design_program_module.g_table_route ;
5769: --
5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)

Line 5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5763: for l_eds_rec in c_eds(l_parent_rec.elig_dsbld_stat_prte_id,l_mirror_src_entity_result_id,'EDS') loop
5764: --
5765: l_table_route_id := null ;
5766: open ben_plan_design_program_module.g_table_route('EDS');
5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5768: close ben_plan_design_program_module.g_table_route ;
5769: --
5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)
5771: || ben_plan_design_program_module.get_exclude_message(l_eds_rec.excld_flag);

Line 5768: close ben_plan_design_program_module.g_table_route ;

5764: --
5765: l_table_route_id := null ;
5766: open ben_plan_design_program_module.g_table_route('EDS');
5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5768: close ben_plan_design_program_module.g_table_route ;
5769: --
5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)
5771: || ben_plan_design_program_module.get_exclude_message(l_eds_rec.excld_flag);
5772: --'Intersection';

Line 5771: || ben_plan_design_program_module.get_exclude_message(l_eds_rec.excld_flag);

5767: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5768: close ben_plan_design_program_module.g_table_route ;
5769: --
5770: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_eds_rec.dsbld_cd)
5771: || ben_plan_design_program_module.get_exclude_message(l_eds_rec.excld_flag);
5772: --'Intersection';
5773: --
5774: if p_effective_date between l_eds_rec.effective_start_date
5775: and l_eds_rec.effective_end_date then

Line 5870: open ben_plan_design_program_module.g_table_route('EES');

5866: --
5867: for l_ees_rec in c_ees(l_parent_rec.elig_ee_stat_prte_id,l_mirror_src_entity_result_id,'EES' ) loop
5868: --
5869: l_table_route_id := null ;
5870: open ben_plan_design_program_module.g_table_route('EES');
5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5872: close ben_plan_design_program_module.g_table_route ;
5873: --
5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)

Line 5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

5867: for l_ees_rec in c_ees(l_parent_rec.elig_ee_stat_prte_id,l_mirror_src_entity_result_id,'EES' ) loop
5868: --
5869: l_table_route_id := null ;
5870: open ben_plan_design_program_module.g_table_route('EES');
5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5872: close ben_plan_design_program_module.g_table_route ;
5873: --
5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)
5875: || ben_plan_design_program_module.get_exclude_message(l_ees_rec.excld_flag);

Line 5872: close ben_plan_design_program_module.g_table_route ;

5868: --
5869: l_table_route_id := null ;
5870: open ben_plan_design_program_module.g_table_route('EES');
5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5872: close ben_plan_design_program_module.g_table_route ;
5873: --
5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)
5875: || ben_plan_design_program_module.get_exclude_message(l_ees_rec.excld_flag);
5876: --'Intersection';

Line 5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)

5870: open ben_plan_design_program_module.g_table_route('EES');
5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5872: close ben_plan_design_program_module.g_table_route ;
5873: --
5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)
5875: || ben_plan_design_program_module.get_exclude_message(l_ees_rec.excld_flag);
5876: --'Intersection';
5877: --
5878: if p_effective_date between l_ees_rec.effective_start_date

Line 5875: || ben_plan_design_program_module.get_exclude_message(l_ees_rec.excld_flag);

5871: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5872: close ben_plan_design_program_module.g_table_route ;
5873: --
5874: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_ees_rec.assignment_status_type_id)
5875: || ben_plan_design_program_module.get_exclude_message(l_ees_rec.excld_flag);
5876: --'Intersection';
5877: --
5878: if p_effective_date between l_ees_rec.effective_start_date
5879: and l_ees_rec.effective_end_date then

Line 6005: open ben_plan_design_program_module.g_table_route('EEI');

6001: --
6002: for l_eei_rec in c_eei(l_parent_rec.elig_enrld_anthr_oipl_id,l_mirror_src_entity_result_id,'EEI' ) loop
6003: --
6004: l_table_route_id := null ;
6005: open ben_plan_design_program_module.g_table_route('EEI');
6006: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6007: close ben_plan_design_program_module.g_table_route ;
6008: --
6009: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eei_rec.oipl_id,p_effective_date)

Line 6006: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6002: for l_eei_rec in c_eei(l_parent_rec.elig_enrld_anthr_oipl_id,l_mirror_src_entity_result_id,'EEI' ) loop
6003: --
6004: l_table_route_id := null ;
6005: open ben_plan_design_program_module.g_table_route('EEI');
6006: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6007: close ben_plan_design_program_module.g_table_route ;
6008: --
6009: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eei_rec.oipl_id,p_effective_date)
6010: --

Line 6007: close ben_plan_design_program_module.g_table_route ;

6003: --
6004: l_table_route_id := null ;
6005: open ben_plan_design_program_module.g_table_route('EEI');
6006: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6007: close ben_plan_design_program_module.g_table_route ;
6008: --
6009: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eei_rec.oipl_id,p_effective_date)
6010: --
6011: -- Bug No: 3451872

Line 6009: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eei_rec.oipl_id,p_effective_date)

6005: open ben_plan_design_program_module.g_table_route('EEI');
6006: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6007: close ben_plan_design_program_module.g_table_route ;
6008: --
6009: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eei_rec.oipl_id,p_effective_date)
6010: --
6011: -- Bug No: 3451872
6012: --
6013: || ' '

Line 6016: || ben_plan_design_program_module.get_exclude_message(l_eei_rec.excld_flag);

6012: --
6013: || ' '
6014: || get_det_enrl_det_dt_name(l_eei_rec.enrl_det_dt_cd,'BEN_ENRL_DET_DT')
6015: --
6016: || ben_plan_design_program_module.get_exclude_message(l_eei_rec.excld_flag);
6017: --'Intersection';
6018: --
6019: if p_effective_date between l_eei_rec.effective_start_date
6020: and l_eei_rec.effective_end_date then

Line 6115: open ben_plan_design_program_module.g_table_route('EEG');

6111: --
6112: for l_eeg_rec in c_eeg(l_parent_rec.elig_enrld_anthr_pgm_id,l_mirror_src_entity_result_id,'EEG' ) loop
6113: --
6114: l_table_route_id := null ;
6115: open ben_plan_design_program_module.g_table_route('EEG');
6116: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6117: close ben_plan_design_program_module.g_table_route ;
6118: --
6119: l_information5 := ben_plan_design_program_module.get_pgm_name(l_eeg_rec.pgm_id,p_effective_date)

Line 6116: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6112: for l_eeg_rec in c_eeg(l_parent_rec.elig_enrld_anthr_pgm_id,l_mirror_src_entity_result_id,'EEG' ) loop
6113: --
6114: l_table_route_id := null ;
6115: open ben_plan_design_program_module.g_table_route('EEG');
6116: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6117: close ben_plan_design_program_module.g_table_route ;
6118: --
6119: l_information5 := ben_plan_design_program_module.get_pgm_name(l_eeg_rec.pgm_id,p_effective_date)
6120: --

Line 6117: close ben_plan_design_program_module.g_table_route ;

6113: --
6114: l_table_route_id := null ;
6115: open ben_plan_design_program_module.g_table_route('EEG');
6116: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6117: close ben_plan_design_program_module.g_table_route ;
6118: --
6119: l_information5 := ben_plan_design_program_module.get_pgm_name(l_eeg_rec.pgm_id,p_effective_date)
6120: --
6121: -- Bug No: 3451872

Line 6119: l_information5 := ben_plan_design_program_module.get_pgm_name(l_eeg_rec.pgm_id,p_effective_date)

6115: open ben_plan_design_program_module.g_table_route('EEG');
6116: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6117: close ben_plan_design_program_module.g_table_route ;
6118: --
6119: l_information5 := ben_plan_design_program_module.get_pgm_name(l_eeg_rec.pgm_id,p_effective_date)
6120: --
6121: -- Bug No: 3451872
6122: --
6123: || ' '

Line 6126: || ben_plan_design_program_module.get_exclude_message(l_eeg_rec.excld_flag);

6122: --
6123: || ' '
6124: || get_det_enrl_det_dt_name(l_eeg_rec.enrl_det_dt_cd,'BEN_ENRL_DET_DT')
6125: --
6126: || ben_plan_design_program_module.get_exclude_message(l_eeg_rec.excld_flag);
6127: --'Intersection';
6128: --
6129: if p_effective_date between l_eeg_rec.effective_start_date
6130: and l_eeg_rec.effective_end_date then

Line 6225: open ben_plan_design_program_module.g_table_route('EAI');

6221: --
6222: for l_eai_rec in c_eai(l_parent_rec.elig_enrld_anthr_plip_id,l_mirror_src_entity_result_id,'EAI' ) loop
6223: --
6224: l_table_route_id := null ;
6225: open ben_plan_design_program_module.g_table_route('EAI');
6226: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6227: close ben_plan_design_program_module.g_table_route ;
6228: --
6229: l_information5 := ben_plan_design_program_module.get_plip_name(l_eai_rec.plip_id,p_effective_date)

Line 6226: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6222: for l_eai_rec in c_eai(l_parent_rec.elig_enrld_anthr_plip_id,l_mirror_src_entity_result_id,'EAI' ) loop
6223: --
6224: l_table_route_id := null ;
6225: open ben_plan_design_program_module.g_table_route('EAI');
6226: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6227: close ben_plan_design_program_module.g_table_route ;
6228: --
6229: l_information5 := ben_plan_design_program_module.get_plip_name(l_eai_rec.plip_id,p_effective_date)
6230: --

Line 6227: close ben_plan_design_program_module.g_table_route ;

6223: --
6224: l_table_route_id := null ;
6225: open ben_plan_design_program_module.g_table_route('EAI');
6226: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6227: close ben_plan_design_program_module.g_table_route ;
6228: --
6229: l_information5 := ben_plan_design_program_module.get_plip_name(l_eai_rec.plip_id,p_effective_date)
6230: --
6231: -- Bug No: 3451872

Line 6229: l_information5 := ben_plan_design_program_module.get_plip_name(l_eai_rec.plip_id,p_effective_date)

6225: open ben_plan_design_program_module.g_table_route('EAI');
6226: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6227: close ben_plan_design_program_module.g_table_route ;
6228: --
6229: l_information5 := ben_plan_design_program_module.get_plip_name(l_eai_rec.plip_id,p_effective_date)
6230: --
6231: -- Bug No: 3451872
6232: --
6233: || ' '

Line 6236: || ben_plan_design_program_module.get_exclude_message(l_eai_rec.excld_flag);

6232: --
6233: || ' '
6234: || get_det_enrl_det_dt_name(l_eai_rec.enrl_det_dt_cd,'BEN_ENRL_DET_DT')
6235: --
6236: || ben_plan_design_program_module.get_exclude_message(l_eai_rec.excld_flag);
6237: --'Intersection';
6238: --
6239: if p_effective_date between l_eai_rec.effective_start_date
6240: and l_eai_rec.effective_end_date then

Line 6335: open ben_plan_design_program_module.g_table_route('EEP');

6331: --
6332: for l_eep_rec in c_eep(l_parent_rec.elig_enrld_anthr_pl_id,l_mirror_src_entity_result_id,'EEP' ) loop
6333: --
6334: l_table_route_id := null ;
6335: open ben_plan_design_program_module.g_table_route('EEP');
6336: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6337: close ben_plan_design_program_module.g_table_route ;
6338: --
6339: l_information5 :=ben_plan_design_program_module.get_pl_name(l_eep_rec.pl_id,p_effective_date)

Line 6336: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6332: for l_eep_rec in c_eep(l_parent_rec.elig_enrld_anthr_pl_id,l_mirror_src_entity_result_id,'EEP' ) loop
6333: --
6334: l_table_route_id := null ;
6335: open ben_plan_design_program_module.g_table_route('EEP');
6336: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6337: close ben_plan_design_program_module.g_table_route ;
6338: --
6339: l_information5 :=ben_plan_design_program_module.get_pl_name(l_eep_rec.pl_id,p_effective_date)
6340: --

Line 6337: close ben_plan_design_program_module.g_table_route ;

6333: --
6334: l_table_route_id := null ;
6335: open ben_plan_design_program_module.g_table_route('EEP');
6336: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6337: close ben_plan_design_program_module.g_table_route ;
6338: --
6339: l_information5 :=ben_plan_design_program_module.get_pl_name(l_eep_rec.pl_id,p_effective_date)
6340: --
6341: -- Bug No: 3451872

Line 6339: l_information5 :=ben_plan_design_program_module.get_pl_name(l_eep_rec.pl_id,p_effective_date)

6335: open ben_plan_design_program_module.g_table_route('EEP');
6336: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6337: close ben_plan_design_program_module.g_table_route ;
6338: --
6339: l_information5 :=ben_plan_design_program_module.get_pl_name(l_eep_rec.pl_id,p_effective_date)
6340: --
6341: -- Bug No: 3451872
6342: --
6343: || ' '

Line 6346: || ben_plan_design_program_module.get_exclude_message(l_eep_rec.excld_flag);

6342: --
6343: || ' '
6344: || get_det_enrl_det_dt_name(l_eep_rec.enrl_det_dt_cd,'BEN_ENRL_DET_DT')
6345: --
6346: || ben_plan_design_program_module.get_exclude_message(l_eep_rec.excld_flag);
6347: --'Intersection';
6348: --
6349: if p_effective_date between l_eep_rec.effective_start_date
6350: and l_eep_rec.effective_end_date then

Line 6445: open ben_plan_design_program_module.g_table_route('EET');

6441: --
6442: for l_eet_rec in c_eet(l_parent_rec.elig_enrld_anthr_ptip_id,l_mirror_src_entity_result_id,'EET' ) loop
6443: --
6444: l_table_route_id := null ;
6445: open ben_plan_design_program_module.g_table_route('EET');
6446: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6447: close ben_plan_design_program_module.g_table_route ;
6448: --
6449: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eet_rec.ptip_id,p_effective_date)

Line 6446: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6442: for l_eet_rec in c_eet(l_parent_rec.elig_enrld_anthr_ptip_id,l_mirror_src_entity_result_id,'EET' ) loop
6443: --
6444: l_table_route_id := null ;
6445: open ben_plan_design_program_module.g_table_route('EET');
6446: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6447: close ben_plan_design_program_module.g_table_route ;
6448: --
6449: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eet_rec.ptip_id,p_effective_date)
6450: --

Line 6447: close ben_plan_design_program_module.g_table_route ;

6443: --
6444: l_table_route_id := null ;
6445: open ben_plan_design_program_module.g_table_route('EET');
6446: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6447: close ben_plan_design_program_module.g_table_route ;
6448: --
6449: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eet_rec.ptip_id,p_effective_date)
6450: --
6451: -- Bug No: 3451872

Line 6449: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eet_rec.ptip_id,p_effective_date)

6445: open ben_plan_design_program_module.g_table_route('EET');
6446: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6447: close ben_plan_design_program_module.g_table_route ;
6448: --
6449: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eet_rec.ptip_id,p_effective_date)
6450: --
6451: -- Bug No: 3451872
6452: --
6453: || ' '

Line 6457: || ben_plan_design_program_module.get_exclude_message(l_eet_rec.excld_flag);

6453: || ' '
6454: || get_det_enrl_det_dt_name(l_eet_rec.enrl_det_dt_cd,'BEN_ENRL_DET_DT')
6455: || get_subj_to_cobra_message(l_eet_rec.only_pls_subj_cobra_flag)
6456: --
6457: || ben_plan_design_program_module.get_exclude_message(l_eet_rec.excld_flag);
6458: --'Intersection';
6459: --
6460: if p_effective_date between l_eet_rec.effective_start_date
6461: and l_eet_rec.effective_end_date then

Line 6558: open ben_plan_design_program_module.g_table_route('EFP');

6554: --
6555: for l_efp_rec in c_efp(l_parent_rec.elig_fl_tm_pt_tm_prte_id,l_mirror_src_entity_result_id,'EFP' ) loop
6556: --
6557: l_table_route_id := null ;
6558: open ben_plan_design_program_module.g_table_route('EFP');
6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6560: close ben_plan_design_program_module.g_table_route ;
6561: --
6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)

Line 6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6555: for l_efp_rec in c_efp(l_parent_rec.elig_fl_tm_pt_tm_prte_id,l_mirror_src_entity_result_id,'EFP' ) loop
6556: --
6557: l_table_route_id := null ;
6558: open ben_plan_design_program_module.g_table_route('EFP');
6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6560: close ben_plan_design_program_module.g_table_route ;
6561: --
6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)
6563: || ben_plan_design_program_module.get_exclude_message(l_efp_rec.excld_flag);

Line 6560: close ben_plan_design_program_module.g_table_route ;

6556: --
6557: l_table_route_id := null ;
6558: open ben_plan_design_program_module.g_table_route('EFP');
6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6560: close ben_plan_design_program_module.g_table_route ;
6561: --
6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)
6563: || ben_plan_design_program_module.get_exclude_message(l_efp_rec.excld_flag);
6564: --'Intersection';

Line 6563: || ben_plan_design_program_module.get_exclude_message(l_efp_rec.excld_flag);

6559: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6560: close ben_plan_design_program_module.g_table_route ;
6561: --
6562: l_information5 := hr_general.decode_lookup('EMP_CAT',l_efp_rec.fl_tm_pt_tm_cd)
6563: || ben_plan_design_program_module.get_exclude_message(l_efp_rec.excld_flag);
6564: --'Intersection';
6565: --
6566: if p_effective_date between l_efp_rec.effective_start_date
6567: and l_efp_rec.effective_end_date then

Line 6664: open ben_plan_design_program_module.g_table_route('EGR');

6660: --
6661: for l_egr_rec in c_egr(l_parent_rec.elig_grd_prte_id,l_mirror_src_entity_result_id,'EGR' ) loop
6662: --
6663: l_table_route_id := null ;
6664: open ben_plan_design_program_module.g_table_route('EGR');
6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6666: close ben_plan_design_program_module.g_table_route ;
6667: --
6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)

Line 6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6661: for l_egr_rec in c_egr(l_parent_rec.elig_grd_prte_id,l_mirror_src_entity_result_id,'EGR' ) loop
6662: --
6663: l_table_route_id := null ;
6664: open ben_plan_design_program_module.g_table_route('EGR');
6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6666: close ben_plan_design_program_module.g_table_route ;
6667: --
6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)
6669: || ben_plan_design_program_module.get_exclude_message(l_egr_rec.excld_flag);

Line 6666: close ben_plan_design_program_module.g_table_route ;

6662: --
6663: l_table_route_id := null ;
6664: open ben_plan_design_program_module.g_table_route('EGR');
6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6666: close ben_plan_design_program_module.g_table_route ;
6667: --
6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)
6669: || ben_plan_design_program_module.get_exclude_message(l_egr_rec.excld_flag);
6670: --'Intersection';

Line 6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)

6664: open ben_plan_design_program_module.g_table_route('EGR');
6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6666: close ben_plan_design_program_module.g_table_route ;
6667: --
6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)
6669: || ben_plan_design_program_module.get_exclude_message(l_egr_rec.excld_flag);
6670: --'Intersection';
6671: --
6672: if p_effective_date between l_egr_rec.effective_start_date

Line 6669: || ben_plan_design_program_module.get_exclude_message(l_egr_rec.excld_flag);

6665: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6666: close ben_plan_design_program_module.g_table_route ;
6667: --
6668: l_information5 := ben_plan_design_program_module.get_grade_name(l_egr_rec.grade_id)
6669: || ben_plan_design_program_module.get_exclude_message(l_egr_rec.excld_flag);
6670: --'Intersection';
6671: --
6672: if p_effective_date between l_egr_rec.effective_start_date
6673: and l_egr_rec.effective_end_date then

Line 6813: open ben_plan_design_program_module.g_table_route('EHS');

6809: --
6810: for l_ehs_rec in c_ehs(l_parent_rec.elig_hrly_slrd_prte_id,l_mirror_src_entity_result_id,'EHS' ) loop
6811: --
6812: l_table_route_id := null ;
6813: open ben_plan_design_program_module.g_table_route('EHS');
6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6815: close ben_plan_design_program_module.g_table_route ;
6816: --
6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)

Line 6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6810: for l_ehs_rec in c_ehs(l_parent_rec.elig_hrly_slrd_prte_id,l_mirror_src_entity_result_id,'EHS' ) loop
6811: --
6812: l_table_route_id := null ;
6813: open ben_plan_design_program_module.g_table_route('EHS');
6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6815: close ben_plan_design_program_module.g_table_route ;
6816: --
6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)
6818: || ben_plan_design_program_module.get_exclude_message(l_ehs_rec.excld_flag);

Line 6815: close ben_plan_design_program_module.g_table_route ;

6811: --
6812: l_table_route_id := null ;
6813: open ben_plan_design_program_module.g_table_route('EHS');
6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6815: close ben_plan_design_program_module.g_table_route ;
6816: --
6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)
6818: || ben_plan_design_program_module.get_exclude_message(l_ehs_rec.excld_flag);
6819: --'Intersection';

Line 6818: || ben_plan_design_program_module.get_exclude_message(l_ehs_rec.excld_flag);

6814: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6815: close ben_plan_design_program_module.g_table_route ;
6816: --
6817: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_ehs_rec.hrly_slrd_cd)
6818: || ben_plan_design_program_module.get_exclude_message(l_ehs_rec.excld_flag);
6819: --'Intersection';
6820: --
6821: if p_effective_date between l_ehs_rec.effective_start_date
6822: and l_ehs_rec.effective_end_date then

Line 6918: open ben_plan_design_program_module.g_table_route('EHW');

6914: --
6915: for l_ehw_rec in c_ehw(l_parent_rec.elig_hrs_wkd_prte_id,l_mirror_src_entity_result_id,'EHW' ) loop
6916: --
6917: l_table_route_id := null ;
6918: open ben_plan_design_program_module.g_table_route('EHW');
6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6920: close ben_plan_design_program_module.g_table_route ;
6921: --
6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)

Line 6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

6915: for l_ehw_rec in c_ehw(l_parent_rec.elig_hrs_wkd_prte_id,l_mirror_src_entity_result_id,'EHW' ) loop
6916: --
6917: l_table_route_id := null ;
6918: open ben_plan_design_program_module.g_table_route('EHW');
6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6920: close ben_plan_design_program_module.g_table_route ;
6921: --
6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)
6923: || ben_plan_design_program_module.get_exclude_message(l_ehw_rec.excld_flag);

Line 6920: close ben_plan_design_program_module.g_table_route ;

6916: --
6917: l_table_route_id := null ;
6918: open ben_plan_design_program_module.g_table_route('EHW');
6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6920: close ben_plan_design_program_module.g_table_route ;
6921: --
6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)
6923: || ben_plan_design_program_module.get_exclude_message(l_ehw_rec.excld_flag);
6924: --'Intersection';

Line 6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)

6918: open ben_plan_design_program_module.g_table_route('EHW');
6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6920: close ben_plan_design_program_module.g_table_route ;
6921: --
6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)
6923: || ben_plan_design_program_module.get_exclude_message(l_ehw_rec.excld_flag);
6924: --'Intersection';
6925: --
6926: if p_effective_date between l_ehw_rec.effective_start_date

Line 6923: || ben_plan_design_program_module.get_exclude_message(l_ehw_rec.excld_flag);

6919: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
6920: close ben_plan_design_program_module.g_table_route ;
6921: --
6922: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_ehw_rec.hrs_wkd_in_perd_fctr_id)
6923: || ben_plan_design_program_module.get_exclude_message(l_ehw_rec.excld_flag);
6924: --'Intersection';
6925: --
6926: if p_effective_date between l_ehw_rec.effective_start_date
6927: and l_ehw_rec.effective_end_date then

Line 7041: open ben_plan_design_program_module.g_table_route('EJP');

7037: --
7038: for l_ejp_rec in c_ejp(l_parent_rec.elig_job_prte_id,l_mirror_src_entity_result_id,'EJP' ) loop
7039: --
7040: l_table_route_id := null ;
7041: open ben_plan_design_program_module.g_table_route('EJP');
7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7043: close ben_plan_design_program_module.g_table_route ;
7044: --
7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)

Line 7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7038: for l_ejp_rec in c_ejp(l_parent_rec.elig_job_prte_id,l_mirror_src_entity_result_id,'EJP' ) loop
7039: --
7040: l_table_route_id := null ;
7041: open ben_plan_design_program_module.g_table_route('EJP');
7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7043: close ben_plan_design_program_module.g_table_route ;
7044: --
7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)
7046: || ben_plan_design_program_module.get_exclude_message(l_ejp_rec.excld_flag); --'Intersection';

Line 7043: close ben_plan_design_program_module.g_table_route ;

7039: --
7040: l_table_route_id := null ;
7041: open ben_plan_design_program_module.g_table_route('EJP');
7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7043: close ben_plan_design_program_module.g_table_route ;
7044: --
7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)
7046: || ben_plan_design_program_module.get_exclude_message(l_ejp_rec.excld_flag); --'Intersection';
7047: --

Line 7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)

7041: open ben_plan_design_program_module.g_table_route('EJP');
7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7043: close ben_plan_design_program_module.g_table_route ;
7044: --
7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)
7046: || ben_plan_design_program_module.get_exclude_message(l_ejp_rec.excld_flag); --'Intersection';
7047: --
7048: if p_effective_date between l_ejp_rec.effective_start_date
7049: and l_ejp_rec.effective_end_date then

Line 7046: || ben_plan_design_program_module.get_exclude_message(l_ejp_rec.excld_flag); --'Intersection';

7042: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7043: close ben_plan_design_program_module.g_table_route ;
7044: --
7045: l_information5 := ben_plan_design_program_module.get_job_name(l_ejp_rec.job_id)
7046: || ben_plan_design_program_module.get_exclude_message(l_ejp_rec.excld_flag); --'Intersection';
7047: --
7048: if p_effective_date between l_ejp_rec.effective_start_date
7049: and l_ejp_rec.effective_end_date then
7050: --

Line 7187: open ben_plan_design_program_module.g_table_route('ELU');

7183: --
7184: for l_elu_rec in c_elu(l_parent_rec.elig_lbr_mmbr_prte_id,l_mirror_src_entity_result_id,'ELU' ) loop
7185: --
7186: l_table_route_id := null ;
7187: open ben_plan_design_program_module.g_table_route('ELU');
7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7189: close ben_plan_design_program_module.g_table_route ;
7190: --
7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)

Line 7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7184: for l_elu_rec in c_elu(l_parent_rec.elig_lbr_mmbr_prte_id,l_mirror_src_entity_result_id,'ELU' ) loop
7185: --
7186: l_table_route_id := null ;
7187: open ben_plan_design_program_module.g_table_route('ELU');
7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7189: close ben_plan_design_program_module.g_table_route ;
7190: --
7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)
7192: || ben_plan_design_program_module.get_exclude_message(l_elu_rec.excld_flag);

Line 7189: close ben_plan_design_program_module.g_table_route ;

7185: --
7186: l_table_route_id := null ;
7187: open ben_plan_design_program_module.g_table_route('ELU');
7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7189: close ben_plan_design_program_module.g_table_route ;
7190: --
7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)
7192: || ben_plan_design_program_module.get_exclude_message(l_elu_rec.excld_flag);
7193: --'Intersection';

Line 7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)

7187: open ben_plan_design_program_module.g_table_route('ELU');
7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7189: close ben_plan_design_program_module.g_table_route ;
7190: --
7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)
7192: || ben_plan_design_program_module.get_exclude_message(l_elu_rec.excld_flag);
7193: --'Intersection';
7194: --
7195: if p_effective_date between l_elu_rec.effective_start_date

Line 7192: || ben_plan_design_program_module.get_exclude_message(l_elu_rec.excld_flag);

7188: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7189: close ben_plan_design_program_module.g_table_route ;
7190: --
7191: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_elu_rec.lbr_mmbr_flag)
7192: || ben_plan_design_program_module.get_exclude_message(l_elu_rec.excld_flag);
7193: --'Intersection';
7194: --
7195: if p_effective_date between l_elu_rec.effective_start_date
7196: and l_elu_rec.effective_end_date then

Line 7293: open ben_plan_design_program_module.g_table_route('ELN');

7289: --
7290: for l_eln_rec in c_eln(l_parent_rec.elig_lgl_enty_prte_id,l_mirror_src_entity_result_id,'ELN' ) loop
7291: --
7292: l_table_route_id := null ;
7293: open ben_plan_design_program_module.g_table_route('ELN');
7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7295: close ben_plan_design_program_module.g_table_route ;
7296: --
7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)

Line 7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7290: for l_eln_rec in c_eln(l_parent_rec.elig_lgl_enty_prte_id,l_mirror_src_entity_result_id,'ELN' ) loop
7291: --
7292: l_table_route_id := null ;
7293: open ben_plan_design_program_module.g_table_route('ELN');
7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7295: close ben_plan_design_program_module.g_table_route ;
7296: --
7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)
7298: || ben_plan_design_program_module.get_exclude_message(l_eln_rec.excld_flag);

Line 7295: close ben_plan_design_program_module.g_table_route ;

7291: --
7292: l_table_route_id := null ;
7293: open ben_plan_design_program_module.g_table_route('ELN');
7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7295: close ben_plan_design_program_module.g_table_route ;
7296: --
7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)
7298: || ben_plan_design_program_module.get_exclude_message(l_eln_rec.excld_flag);
7299: --'Intersection';

Line 7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)

7293: open ben_plan_design_program_module.g_table_route('ELN');
7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7295: close ben_plan_design_program_module.g_table_route ;
7296: --
7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)
7298: || ben_plan_design_program_module.get_exclude_message(l_eln_rec.excld_flag);
7299: --'Intersection';
7300: --
7301: if p_effective_date between l_eln_rec.effective_start_date

Line 7298: || ben_plan_design_program_module.get_exclude_message(l_eln_rec.excld_flag);

7294: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7295: close ben_plan_design_program_module.g_table_route ;
7296: --
7297: l_information5 := ben_plan_design_program_module.get_organization_name(l_eln_rec.organization_id)
7298: || ben_plan_design_program_module.get_exclude_message(l_eln_rec.excld_flag);
7299: --'Intersection';
7300: --
7301: if p_effective_date between l_eln_rec.effective_start_date
7302: and l_eln_rec.effective_end_date then

Line 7443: open ben_plan_design_program_module.g_table_route('ECY');

7439: --
7440: for l_ecy_rec in c_ecy(l_parent_rec.elig_comptncy_prte_id,l_mirror_src_entity_result_id,'ECY' ) loop
7441: --
7442: l_table_route_id := null ;
7443: open ben_plan_design_program_module.g_table_route('ECY');
7444: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7445: close ben_plan_design_program_module.g_table_route ;
7446: --
7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name

Line 7444: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7440: for l_ecy_rec in c_ecy(l_parent_rec.elig_comptncy_prte_id,l_mirror_src_entity_result_id,'ECY' ) loop
7441: --
7442: l_table_route_id := null ;
7443: open ben_plan_design_program_module.g_table_route('ECY');
7444: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7445: close ben_plan_design_program_module.g_table_route ;
7446: --
7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name
7448: (l_ecy_rec.competence_id

Line 7445: close ben_plan_design_program_module.g_table_route ;

7441: --
7442: l_table_route_id := null ;
7443: open ben_plan_design_program_module.g_table_route('ECY');
7444: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7445: close ben_plan_design_program_module.g_table_route ;
7446: --
7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name
7448: (l_ecy_rec.competence_id
7449: ,l_ecy_rec.rating_level_id)

Line 7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name

7443: open ben_plan_design_program_module.g_table_route('ECY');
7444: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7445: close ben_plan_design_program_module.g_table_route ;
7446: --
7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name
7448: (l_ecy_rec.competence_id
7449: ,l_ecy_rec.rating_level_id)
7450: || ben_plan_design_program_module.get_exclude_message(l_ecy_rec.excld_flag);
7451: -- 'Intersection'

Line 7450: || ben_plan_design_program_module.get_exclude_message(l_ecy_rec.excld_flag);

7446: --
7447: l_information5 := ben_plan_design_program_module.get_competence_rating_name
7448: (l_ecy_rec.competence_id
7449: ,l_ecy_rec.rating_level_id)
7450: || ben_plan_design_program_module.get_exclude_message(l_ecy_rec.excld_flag);
7451: -- 'Intersection'
7452: --
7453: if p_effective_date between l_ecy_rec.effective_start_date
7454: and l_ecy_rec.effective_end_date then

Line 7611: open ben_plan_design_program_module.g_table_route('ELR');

7607: --
7608: for l_elr_rec in c_elr(l_parent_rec.elig_loa_rsn_prte_id,l_mirror_src_entity_result_id,'ELR' ) loop
7609: --
7610: l_table_route_id := null ;
7611: open ben_plan_design_program_module.g_table_route('ELR');
7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7613: close ben_plan_design_program_module.g_table_route ;
7614: --
7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)

Line 7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7608: for l_elr_rec in c_elr(l_parent_rec.elig_loa_rsn_prte_id,l_mirror_src_entity_result_id,'ELR' ) loop
7609: --
7610: l_table_route_id := null ;
7611: open ben_plan_design_program_module.g_table_route('ELR');
7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7613: close ben_plan_design_program_module.g_table_route ;
7614: --
7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)
7616: || ben_plan_design_program_module.get_exclude_message(l_elr_rec.excld_flag);

Line 7613: close ben_plan_design_program_module.g_table_route ;

7609: --
7610: l_table_route_id := null ;
7611: open ben_plan_design_program_module.g_table_route('ELR');
7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7613: close ben_plan_design_program_module.g_table_route ;
7614: --
7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)
7616: || ben_plan_design_program_module.get_exclude_message(l_elr_rec.excld_flag);
7617: --'Intersection'

Line 7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)

7611: open ben_plan_design_program_module.g_table_route('ELR');
7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7613: close ben_plan_design_program_module.g_table_route ;
7614: --
7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)
7616: || ben_plan_design_program_module.get_exclude_message(l_elr_rec.excld_flag);
7617: --'Intersection'
7618: --
7619: if p_effective_date between l_elr_rec.effective_start_date

Line 7616: || ben_plan_design_program_module.get_exclude_message(l_elr_rec.excld_flag);

7612: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7613: close ben_plan_design_program_module.g_table_route ;
7614: --
7615: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_elr_rec.absence_attendance_type_id)
7616: || ben_plan_design_program_module.get_exclude_message(l_elr_rec.excld_flag);
7617: --'Intersection'
7618: --
7619: if p_effective_date between l_elr_rec.effective_start_date
7620: and l_elr_rec.effective_end_date then

Line 7773: open ben_plan_design_program_module.g_table_route('ELS');

7769: --
7770: for l_els_rec in c_els(l_parent_rec.elig_los_prte_id,l_mirror_src_entity_result_id,'ELS') loop
7771: --
7772: l_table_route_id := null ;
7773: open ben_plan_design_program_module.g_table_route('ELS');
7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7775: close ben_plan_design_program_module.g_table_route ;
7776: --
7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)

Line 7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7770: for l_els_rec in c_els(l_parent_rec.elig_los_prte_id,l_mirror_src_entity_result_id,'ELS') loop
7771: --
7772: l_table_route_id := null ;
7773: open ben_plan_design_program_module.g_table_route('ELS');
7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7775: close ben_plan_design_program_module.g_table_route ;
7776: --
7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)
7778: || ben_plan_design_program_module.get_exclude_message(l_els_rec.excld_flag);

Line 7775: close ben_plan_design_program_module.g_table_route ;

7771: --
7772: l_table_route_id := null ;
7773: open ben_plan_design_program_module.g_table_route('ELS');
7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7775: close ben_plan_design_program_module.g_table_route ;
7776: --
7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)
7778: || ben_plan_design_program_module.get_exclude_message(l_els_rec.excld_flag);
7779: --'Intersection'

Line 7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)

7773: open ben_plan_design_program_module.g_table_route('ELS');
7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7775: close ben_plan_design_program_module.g_table_route ;
7776: --
7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)
7778: || ben_plan_design_program_module.get_exclude_message(l_els_rec.excld_flag);
7779: --'Intersection'
7780: --
7781: if p_effective_date between l_els_rec.effective_start_date

Line 7778: || ben_plan_design_program_module.get_exclude_message(l_els_rec.excld_flag);

7774: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7775: close ben_plan_design_program_module.g_table_route ;
7776: --
7777: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_els_rec.los_fctr_id)
7778: || ben_plan_design_program_module.get_exclude_message(l_els_rec.excld_flag);
7779: --'Intersection'
7780: --
7781: if p_effective_date between l_els_rec.effective_start_date
7782: and l_els_rec.effective_end_date then

Line 7896: open ben_plan_design_program_module.g_table_route('ELV');

7892: --
7893: for l_elv_rec in c_elv(l_parent_rec.elig_lvg_rsn_prte_id,l_mirror_src_entity_result_id,'ELV') loop
7894: --
7895: l_table_route_id := null ;
7896: open ben_plan_design_program_module.g_table_route('ELV');
7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7898: close ben_plan_design_program_module.g_table_route ;
7899: --
7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)

Line 7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7893: for l_elv_rec in c_elv(l_parent_rec.elig_lvg_rsn_prte_id,l_mirror_src_entity_result_id,'ELV') loop
7894: --
7895: l_table_route_id := null ;
7896: open ben_plan_design_program_module.g_table_route('ELV');
7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7898: close ben_plan_design_program_module.g_table_route ;
7899: --
7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)
7901: || ben_plan_design_program_module.get_exclude_message(l_elv_rec.excld_flag);

Line 7898: close ben_plan_design_program_module.g_table_route ;

7894: --
7895: l_table_route_id := null ;
7896: open ben_plan_design_program_module.g_table_route('ELV');
7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7898: close ben_plan_design_program_module.g_table_route ;
7899: --
7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)
7901: || ben_plan_design_program_module.get_exclude_message(l_elv_rec.excld_flag);
7902: --'Intersection';

Line 7901: || ben_plan_design_program_module.get_exclude_message(l_elv_rec.excld_flag);

7897: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7898: close ben_plan_design_program_module.g_table_route ;
7899: --
7900: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_elv_rec.lvg_rsn_cd)
7901: || ben_plan_design_program_module.get_exclude_message(l_elv_rec.excld_flag);
7902: --'Intersection';
7903: --
7904: if p_effective_date between l_elv_rec.effective_start_date
7905: and l_elv_rec.effective_end_date then

Line 8001: open ben_plan_design_program_module.g_table_route('ENO');

7997: --
7998: for l_eno_rec in c_eno(l_parent_rec.elig_no_othr_cvg_prte_id,l_mirror_src_entity_result_id,'ENO' ) loop
7999: --
8000: l_table_route_id := null ;
8001: open ben_plan_design_program_module.g_table_route('ENO');
8002: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8003: close ben_plan_design_program_module.g_table_route ;
8004: --
8005: l_information5 := hr_general.decode_lookup('YES_NO',l_eno_rec.coord_ben_no_cvg_flag);

Line 8002: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

7998: for l_eno_rec in c_eno(l_parent_rec.elig_no_othr_cvg_prte_id,l_mirror_src_entity_result_id,'ENO' ) loop
7999: --
8000: l_table_route_id := null ;
8001: open ben_plan_design_program_module.g_table_route('ENO');
8002: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8003: close ben_plan_design_program_module.g_table_route ;
8004: --
8005: l_information5 := hr_general.decode_lookup('YES_NO',l_eno_rec.coord_ben_no_cvg_flag);
8006: --'Intersection';

Line 8003: close ben_plan_design_program_module.g_table_route ;

7999: --
8000: l_table_route_id := null ;
8001: open ben_plan_design_program_module.g_table_route('ENO');
8002: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8003: close ben_plan_design_program_module.g_table_route ;
8004: --
8005: l_information5 := hr_general.decode_lookup('YES_NO',l_eno_rec.coord_ben_no_cvg_flag);
8006: --'Intersection';
8007: --

Line 8101: open ben_plan_design_program_module.g_table_route('EOM');

8097: --
8098: for l_eom_rec in c_eom(l_parent_rec.elig_optd_mdcr_prte_id,l_mirror_src_entity_result_id,'EOM' ) loop
8099: --
8100: l_table_route_id := null ;
8101: open ben_plan_design_program_module.g_table_route('EOM');
8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8103: close ben_plan_design_program_module.g_table_route ;
8104: --
8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)

Line 8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8098: for l_eom_rec in c_eom(l_parent_rec.elig_optd_mdcr_prte_id,l_mirror_src_entity_result_id,'EOM' ) loop
8099: --
8100: l_table_route_id := null ;
8101: open ben_plan_design_program_module.g_table_route('EOM');
8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8103: close ben_plan_design_program_module.g_table_route ;
8104: --
8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)
8106: || ben_plan_design_program_module.get_exclude_message(l_eom_rec.exlcd_flag);

Line 8103: close ben_plan_design_program_module.g_table_route ;

8099: --
8100: l_table_route_id := null ;
8101: open ben_plan_design_program_module.g_table_route('EOM');
8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8103: close ben_plan_design_program_module.g_table_route ;
8104: --
8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)
8106: || ben_plan_design_program_module.get_exclude_message(l_eom_rec.exlcd_flag);
8107: --'Intersection';

Line 8106: || ben_plan_design_program_module.get_exclude_message(l_eom_rec.exlcd_flag);

8102: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8103: close ben_plan_design_program_module.g_table_route ;
8104: --
8105: l_information5 := hr_general.decode_lookup('YES_NO',l_eom_rec.optd_mdcr_flag)
8106: || ben_plan_design_program_module.get_exclude_message(l_eom_rec.exlcd_flag);
8107: --'Intersection';
8108: --
8109: if p_effective_date between l_eom_rec.effective_start_date
8110: and l_eom_rec.effective_end_date then

Line 8203: open ben_plan_design_program_module.g_table_route('EOU');

8199: --
8200: for l_eou_rec in c_eou(l_parent_rec.elig_org_unit_prte_id,l_mirror_src_entity_result_id,'EOU' ) loop
8201: --
8202: l_table_route_id := null ;
8203: open ben_plan_design_program_module.g_table_route('EOU');
8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8205: close ben_plan_design_program_module.g_table_route ;
8206: --
8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)

Line 8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8200: for l_eou_rec in c_eou(l_parent_rec.elig_org_unit_prte_id,l_mirror_src_entity_result_id,'EOU' ) loop
8201: --
8202: l_table_route_id := null ;
8203: open ben_plan_design_program_module.g_table_route('EOU');
8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8205: close ben_plan_design_program_module.g_table_route ;
8206: --
8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)
8208: || ben_plan_design_program_module.get_exclude_message(l_eou_rec.excld_flag);

Line 8205: close ben_plan_design_program_module.g_table_route ;

8201: --
8202: l_table_route_id := null ;
8203: open ben_plan_design_program_module.g_table_route('EOU');
8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8205: close ben_plan_design_program_module.g_table_route ;
8206: --
8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)
8208: || ben_plan_design_program_module.get_exclude_message(l_eou_rec.excld_flag);
8209: --'Intersection';

Line 8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)

8203: open ben_plan_design_program_module.g_table_route('EOU');
8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8205: close ben_plan_design_program_module.g_table_route ;
8206: --
8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)
8208: || ben_plan_design_program_module.get_exclude_message(l_eou_rec.excld_flag);
8209: --'Intersection';
8210: --
8211: if p_effective_date between l_eou_rec.effective_start_date

Line 8208: || ben_plan_design_program_module.get_exclude_message(l_eou_rec.excld_flag);

8204: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8205: close ben_plan_design_program_module.g_table_route ;
8206: --
8207: l_information5 := ben_plan_design_program_module.get_organization_name(l_eou_rec.organization_id)
8208: || ben_plan_design_program_module.get_exclude_message(l_eou_rec.excld_flag);
8209: --'Intersection';
8210: --
8211: if p_effective_date between l_eou_rec.effective_start_date
8212: and l_eou_rec.effective_end_date then

Line 8351: open ben_plan_design_program_module.g_table_route('EOY');

8347: --
8348: for l_eoy_rec in c_eoy(l_parent_rec.elig_othr_ptip_prte_id,l_mirror_src_entity_result_id,'EOY' ) loop
8349: --
8350: l_table_route_id := null ;
8351: open ben_plan_design_program_module.g_table_route('EOY');
8352: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8353: close ben_plan_design_program_module.g_table_route ;
8354: --
8355: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eoy_rec.ptip_id,p_effective_date)

Line 8352: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8348: for l_eoy_rec in c_eoy(l_parent_rec.elig_othr_ptip_prte_id,l_mirror_src_entity_result_id,'EOY' ) loop
8349: --
8350: l_table_route_id := null ;
8351: open ben_plan_design_program_module.g_table_route('EOY');
8352: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8353: close ben_plan_design_program_module.g_table_route ;
8354: --
8355: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eoy_rec.ptip_id,p_effective_date)
8356: --

Line 8353: close ben_plan_design_program_module.g_table_route ;

8349: --
8350: l_table_route_id := null ;
8351: open ben_plan_design_program_module.g_table_route('EOY');
8352: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8353: close ben_plan_design_program_module.g_table_route ;
8354: --
8355: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eoy_rec.ptip_id,p_effective_date)
8356: --
8357: -- Bug No: 3451872

Line 8355: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eoy_rec.ptip_id,p_effective_date)

8351: open ben_plan_design_program_module.g_table_route('EOY');
8352: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8353: close ben_plan_design_program_module.g_table_route ;
8354: --
8355: l_information5 := ben_plan_design_program_module.get_ptip_name(l_eoy_rec.ptip_id,p_effective_date)
8356: --
8357: -- Bug No: 3451872
8358: --
8359: || get_subj_to_cobra_message(l_eoy_rec.only_pls_subj_cobra_flag)

Line 8361: || ben_plan_design_program_module.get_exclude_message(l_eoy_rec.excld_flag);

8357: -- Bug No: 3451872
8358: --
8359: || get_subj_to_cobra_message(l_eoy_rec.only_pls_subj_cobra_flag)
8360: --
8361: || ben_plan_design_program_module.get_exclude_message(l_eoy_rec.excld_flag);
8362: --'Intersection';
8363: --
8364: if p_effective_date between l_eoy_rec.effective_start_date
8365: and l_eoy_rec.effective_end_date then

Line 8460: open ben_plan_design_program_module.g_table_route('EPF');

8456: --
8457: for l_epf_rec in c_epf(l_parent_rec.elig_pct_fl_tm_prte_id,l_mirror_src_entity_result_id,'EPF' ) loop
8458: --
8459: l_table_route_id := null ;
8460: open ben_plan_design_program_module.g_table_route('EPF');
8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8462: close ben_plan_design_program_module.g_table_route ;
8463: --
8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)

Line 8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8457: for l_epf_rec in c_epf(l_parent_rec.elig_pct_fl_tm_prte_id,l_mirror_src_entity_result_id,'EPF' ) loop
8458: --
8459: l_table_route_id := null ;
8460: open ben_plan_design_program_module.g_table_route('EPF');
8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8462: close ben_plan_design_program_module.g_table_route ;
8463: --
8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)
8465: || ben_plan_design_program_module.get_exclude_message(l_epf_rec.excld_flag);

Line 8462: close ben_plan_design_program_module.g_table_route ;

8458: --
8459: l_table_route_id := null ;
8460: open ben_plan_design_program_module.g_table_route('EPF');
8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8462: close ben_plan_design_program_module.g_table_route ;
8463: --
8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)
8465: || ben_plan_design_program_module.get_exclude_message(l_epf_rec.excld_flag);
8466: --'Intersection';

Line 8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)

8460: open ben_plan_design_program_module.g_table_route('EPF');
8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8462: close ben_plan_design_program_module.g_table_route ;
8463: --
8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)
8465: || ben_plan_design_program_module.get_exclude_message(l_epf_rec.excld_flag);
8466: --'Intersection';
8467: --
8468: if p_effective_date between l_epf_rec.effective_start_date

Line 8465: || ben_plan_design_program_module.get_exclude_message(l_epf_rec.excld_flag);

8461: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8462: close ben_plan_design_program_module.g_table_route ;
8463: --
8464: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_epf_rec.pct_fl_tm_fctr_id)
8465: || ben_plan_design_program_module.get_exclude_message(l_epf_rec.excld_flag);
8466: --'Intersection';
8467: --
8468: if p_effective_date between l_epf_rec.effective_start_date
8469: and l_epf_rec.effective_end_date then

Line 8584: open ben_plan_design_program_module.g_table_route('EPT');

8580: --
8581: for l_ept_rec in c_ept(l_parent_rec.elig_per_typ_prte_id,l_mirror_src_entity_result_id,'EPT' ) loop
8582: --
8583: l_table_route_id := null ;
8584: open ben_plan_design_program_module.g_table_route('EPT');
8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8586: close ben_plan_design_program_module.g_table_route ;
8587: --
8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)

Line 8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8581: for l_ept_rec in c_ept(l_parent_rec.elig_per_typ_prte_id,l_mirror_src_entity_result_id,'EPT' ) loop
8582: --
8583: l_table_route_id := null ;
8584: open ben_plan_design_program_module.g_table_route('EPT');
8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8586: close ben_plan_design_program_module.g_table_route ;
8587: --
8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)
8589: || ben_plan_design_program_module.get_exclude_message(l_ept_rec.excld_flag);

Line 8586: close ben_plan_design_program_module.g_table_route ;

8582: --
8583: l_table_route_id := null ;
8584: open ben_plan_design_program_module.g_table_route('EPT');
8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8586: close ben_plan_design_program_module.g_table_route ;
8587: --
8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)
8589: || ben_plan_design_program_module.get_exclude_message(l_ept_rec.excld_flag);
8590: --'Intersection';

Line 8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)

8584: open ben_plan_design_program_module.g_table_route('EPT');
8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8586: close ben_plan_design_program_module.g_table_route ;
8587: --
8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)
8589: || ben_plan_design_program_module.get_exclude_message(l_ept_rec.excld_flag);
8590: --'Intersection';
8591: --
8592: if p_effective_date between l_ept_rec.effective_start_date

Line 8589: || ben_plan_design_program_module.get_exclude_message(l_ept_rec.excld_flag);

8585: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8586: close ben_plan_design_program_module.g_table_route ;
8587: --
8588: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ept_rec.person_type_id)
8589: || ben_plan_design_program_module.get_exclude_message(l_ept_rec.excld_flag);
8590: --'Intersection';
8591: --
8592: if p_effective_date between l_ept_rec.effective_start_date
8593: and l_ept_rec.effective_end_date then

Line 8721: open ben_plan_design_program_module.g_table_route('EPG');

8717: --
8718: for l_epg_rec in c_epg(l_parent_rec.elig_ppl_grp_prte_id,l_mirror_src_entity_result_id,'EPG' ) loop
8719: --
8720: l_table_route_id := null ;
8721: open ben_plan_design_program_module.g_table_route('EPG');
8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8723: close ben_plan_design_program_module.g_table_route ;
8724: --
8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)

Line 8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8718: for l_epg_rec in c_epg(l_parent_rec.elig_ppl_grp_prte_id,l_mirror_src_entity_result_id,'EPG' ) loop
8719: --
8720: l_table_route_id := null ;
8721: open ben_plan_design_program_module.g_table_route('EPG');
8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8723: close ben_plan_design_program_module.g_table_route ;
8724: --
8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)
8726: || ben_plan_design_program_module.get_exclude_message(l_epg_rec.excld_flag);

Line 8723: close ben_plan_design_program_module.g_table_route ;

8719: --
8720: l_table_route_id := null ;
8721: open ben_plan_design_program_module.g_table_route('EPG');
8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8723: close ben_plan_design_program_module.g_table_route ;
8724: --
8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)
8726: || ben_plan_design_program_module.get_exclude_message(l_epg_rec.excld_flag);
8727: --'Intersection';

Line 8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)

8721: open ben_plan_design_program_module.g_table_route('EPG');
8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8723: close ben_plan_design_program_module.g_table_route ;
8724: --
8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)
8726: || ben_plan_design_program_module.get_exclude_message(l_epg_rec.excld_flag);
8727: --'Intersection';
8728: --
8729: if p_effective_date between l_epg_rec.effective_start_date

Line 8726: || ben_plan_design_program_module.get_exclude_message(l_epg_rec.excld_flag);

8722: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8723: close ben_plan_design_program_module.g_table_route ;
8724: --
8725: l_information5 := ben_plan_design_program_module.get_people_group_name(l_epg_rec.people_group_id)
8726: || ben_plan_design_program_module.get_exclude_message(l_epg_rec.excld_flag);
8727: --'Intersection';
8728: --
8729: if p_effective_date between l_epg_rec.effective_start_date
8730: and l_epg_rec.effective_end_date then

Line 8826: open ben_plan_design_program_module.g_table_route('EPP');

8822: --
8823: for l_epp_rec in c_epp(l_parent_rec.elig_prtt_anthr_pl_prte_id,l_mirror_src_entity_result_id,'EPP' ) loop
8824: --
8825: l_table_route_id := null ;
8826: open ben_plan_design_program_module.g_table_route('EPP');
8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8828: close ben_plan_design_program_module.g_table_route ;
8829: --
8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)

Line 8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8823: for l_epp_rec in c_epp(l_parent_rec.elig_prtt_anthr_pl_prte_id,l_mirror_src_entity_result_id,'EPP' ) loop
8824: --
8825: l_table_route_id := null ;
8826: open ben_plan_design_program_module.g_table_route('EPP');
8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8828: close ben_plan_design_program_module.g_table_route ;
8829: --
8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)
8831: || ben_plan_design_program_module.get_exclude_message(l_epp_rec.excld_flag);

Line 8828: close ben_plan_design_program_module.g_table_route ;

8824: --
8825: l_table_route_id := null ;
8826: open ben_plan_design_program_module.g_table_route('EPP');
8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8828: close ben_plan_design_program_module.g_table_route ;
8829: --
8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)
8831: || ben_plan_design_program_module.get_exclude_message(l_epp_rec.excld_flag);
8832: --'Intersection';

Line 8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)

8826: open ben_plan_design_program_module.g_table_route('EPP');
8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8828: close ben_plan_design_program_module.g_table_route ;
8829: --
8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)
8831: || ben_plan_design_program_module.get_exclude_message(l_epp_rec.excld_flag);
8832: --'Intersection';
8833: --
8834: if p_effective_date between l_epp_rec.effective_start_date

Line 8831: || ben_plan_design_program_module.get_exclude_message(l_epp_rec.excld_flag);

8827: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8828: close ben_plan_design_program_module.g_table_route ;
8829: --
8830: l_information5 := ben_plan_design_program_module.get_pl_name(l_epp_rec.pl_id,p_effective_date)
8831: || ben_plan_design_program_module.get_exclude_message(l_epp_rec.excld_flag);
8832: --'Intersection';
8833: --
8834: if p_effective_date between l_epp_rec.effective_start_date
8835: and l_epp_rec.effective_end_date then

Line 8931: open ben_plan_design_program_module.g_table_route('EPZ');

8927: --
8928: for l_epz_rec in c_epz(l_parent_rec.elig_pstl_cd_r_rng_prte_id,l_mirror_src_entity_result_id,'EPZ' ) loop
8929: --
8930: l_table_route_id := null ;
8931: open ben_plan_design_program_module.g_table_route('EPZ');
8932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8933: close ben_plan_design_program_module.g_table_route ;
8934: --
8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id

Line 8932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

8928: for l_epz_rec in c_epz(l_parent_rec.elig_pstl_cd_r_rng_prte_id,l_mirror_src_entity_result_id,'EPZ' ) loop
8929: --
8930: l_table_route_id := null ;
8931: open ben_plan_design_program_module.g_table_route('EPZ');
8932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8933: close ben_plan_design_program_module.g_table_route ;
8934: --
8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id
8936: ,p_effective_date)

Line 8933: close ben_plan_design_program_module.g_table_route ;

8929: --
8930: l_table_route_id := null ;
8931: open ben_plan_design_program_module.g_table_route('EPZ');
8932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8933: close ben_plan_design_program_module.g_table_route ;
8934: --
8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id
8936: ,p_effective_date)
8937: || ben_plan_design_program_module.get_exclude_message(l_epz_rec.excld_flag);

Line 8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id

8931: open ben_plan_design_program_module.g_table_route('EPZ');
8932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8933: close ben_plan_design_program_module.g_table_route ;
8934: --
8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id
8936: ,p_effective_date)
8937: || ben_plan_design_program_module.get_exclude_message(l_epz_rec.excld_flag);
8938: --'Intersection';
8939: --

Line 8937: || ben_plan_design_program_module.get_exclude_message(l_epz_rec.excld_flag);

8933: close ben_plan_design_program_module.g_table_route ;
8934: --
8935: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epz_rec.pstl_zip_rng_id
8936: ,p_effective_date)
8937: || ben_plan_design_program_module.get_exclude_message(l_epz_rec.excld_flag);
8938: --'Intersection';
8939: --
8940: if p_effective_date between l_epz_rec.effective_start_date
8941: and l_epz_rec.effective_end_date then

Line 9050: open ben_plan_design_program_module.g_table_route('EPY');

9046: --
9047: for l_epy_rec in c_epy(l_parent_rec.elig_pyrl_prte_id,l_mirror_src_entity_result_id,'EPY' ) loop
9048: --
9049: l_table_route_id := null ;
9050: open ben_plan_design_program_module.g_table_route('EPY');
9051: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9052: close ben_plan_design_program_module.g_table_route ;
9053: --
9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id

Line 9051: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9047: for l_epy_rec in c_epy(l_parent_rec.elig_pyrl_prte_id,l_mirror_src_entity_result_id,'EPY' ) loop
9048: --
9049: l_table_route_id := null ;
9050: open ben_plan_design_program_module.g_table_route('EPY');
9051: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9052: close ben_plan_design_program_module.g_table_route ;
9053: --
9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id
9055: ,p_effective_date)

Line 9052: close ben_plan_design_program_module.g_table_route ;

9048: --
9049: l_table_route_id := null ;
9050: open ben_plan_design_program_module.g_table_route('EPY');
9051: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9052: close ben_plan_design_program_module.g_table_route ;
9053: --
9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id
9055: ,p_effective_date)
9056: || ben_plan_design_program_module.get_exclude_message(l_epy_rec.excld_flag);

Line 9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id

9050: open ben_plan_design_program_module.g_table_route('EPY');
9051: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9052: close ben_plan_design_program_module.g_table_route ;
9053: --
9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id
9055: ,p_effective_date)
9056: || ben_plan_design_program_module.get_exclude_message(l_epy_rec.excld_flag);
9057: --'Intersection';
9058: --

Line 9056: || ben_plan_design_program_module.get_exclude_message(l_epy_rec.excld_flag);

9052: close ben_plan_design_program_module.g_table_route ;
9053: --
9054: l_information5 := ben_plan_design_program_module.get_payroll_name(l_epy_rec.payroll_id
9055: ,p_effective_date)
9056: || ben_plan_design_program_module.get_exclude_message(l_epy_rec.excld_flag);
9057: --'Intersection';
9058: --
9059: if p_effective_date between l_epy_rec.effective_start_date
9060: and l_epy_rec.effective_end_date then

Line 9198: open ben_plan_design_program_module.g_table_route('EPB');

9194: --
9195: for l_epb_rec in c_epb(l_parent_rec.elig_py_bss_prte_id,l_mirror_src_entity_result_id,'EPB' ) loop
9196: --
9197: l_table_route_id := null ;
9198: open ben_plan_design_program_module.g_table_route('EPB');
9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9200: close ben_plan_design_program_module.g_table_route ;
9201: --
9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)

Line 9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9195: for l_epb_rec in c_epb(l_parent_rec.elig_py_bss_prte_id,l_mirror_src_entity_result_id,'EPB' ) loop
9196: --
9197: l_table_route_id := null ;
9198: open ben_plan_design_program_module.g_table_route('EPB');
9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9200: close ben_plan_design_program_module.g_table_route ;
9201: --
9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)
9203: || ben_plan_design_program_module.get_exclude_message(l_epb_rec.excld_flag);

Line 9200: close ben_plan_design_program_module.g_table_route ;

9196: --
9197: l_table_route_id := null ;
9198: open ben_plan_design_program_module.g_table_route('EPB');
9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9200: close ben_plan_design_program_module.g_table_route ;
9201: --
9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)
9203: || ben_plan_design_program_module.get_exclude_message(l_epb_rec.excld_flag);
9204: --'Intersection';

Line 9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)

9198: open ben_plan_design_program_module.g_table_route('EPB');
9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9200: close ben_plan_design_program_module.g_table_route ;
9201: --
9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)
9203: || ben_plan_design_program_module.get_exclude_message(l_epb_rec.excld_flag);
9204: --'Intersection';
9205: --
9206: if p_effective_date between l_epb_rec.effective_start_date

Line 9203: || ben_plan_design_program_module.get_exclude_message(l_epb_rec.excld_flag);

9199: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9200: close ben_plan_design_program_module.g_table_route ;
9201: --
9202: l_information5 := ben_plan_design_program_module.get_pay_basis_name(l_epb_rec.pay_basis_id)
9203: || ben_plan_design_program_module.get_exclude_message(l_epb_rec.excld_flag);
9204: --'Intersection';
9205: --
9206: if p_effective_date between l_epb_rec.effective_start_date
9207: and l_epb_rec.effective_end_date then

Line 9333: open ben_plan_design_program_module.g_table_route('ESH');

9329: --
9330: for l_esh_rec in c_esh(l_parent_rec.elig_schedd_hrs_prte_id,l_mirror_src_entity_result_id,'ESH' ) loop
9331: --
9332: l_table_route_id := null ;
9333: open ben_plan_design_program_module.g_table_route('ESH');
9334: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9335: close ben_plan_design_program_module.g_table_route ;
9336: --
9337: -- Bug No: 3451872

Line 9334: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9330: for l_esh_rec in c_esh(l_parent_rec.elig_schedd_hrs_prte_id,l_mirror_src_entity_result_id,'ESH' ) loop
9331: --
9332: l_table_route_id := null ;
9333: open ben_plan_design_program_module.g_table_route('ESH');
9334: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9335: close ben_plan_design_program_module.g_table_route ;
9336: --
9337: -- Bug No: 3451872
9338: --

Line 9335: close ben_plan_design_program_module.g_table_route ;

9331: --
9332: l_table_route_id := null ;
9333: open ben_plan_design_program_module.g_table_route('ESH');
9334: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9335: close ben_plan_design_program_module.g_table_route ;
9336: --
9337: -- Bug No: 3451872
9338: --
9339: if (l_esh_rec.schedd_hrs_rl is null) then

Line 9342: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);

9338: --
9339: if (l_esh_rec.schedd_hrs_rl is null) then
9340: l_information5 := l_esh_rec.hrs_num ||' - ' ||l_esh_rec.max_hrs_num
9341: ||' '||hr_general.decode_lookup('FREQUENCY',l_esh_rec.freq_cd)
9342: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9343:
9344: else
9345: l_information5 := ben_plan_design_program_module.get_formula_name(l_esh_rec.schedd_hrs_rl, p_effective_date)
9346: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);

Line 9345: l_information5 := ben_plan_design_program_module.get_formula_name(l_esh_rec.schedd_hrs_rl, p_effective_date)

9341: ||' '||hr_general.decode_lookup('FREQUENCY',l_esh_rec.freq_cd)
9342: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9343:
9344: else
9345: l_information5 := ben_plan_design_program_module.get_formula_name(l_esh_rec.schedd_hrs_rl, p_effective_date)
9346: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9347: --'Intersection';
9348: end if;
9349: --

Line 9346: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);

9342: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9343:
9344: else
9345: l_information5 := ben_plan_design_program_module.get_formula_name(l_esh_rec.schedd_hrs_rl, p_effective_date)
9346: || ben_plan_design_program_module.get_exclude_message(l_esh_rec.excld_flag);
9347: --'Intersection';
9348: end if;
9349: --
9350: if p_effective_date between l_esh_rec.effective_start_date

Line 9437: ben_plan_design_program_module.create_formula_result(

9433: end if;
9434: --
9435:
9436: if (l_esh_rec.determination_rl is not null) then
9437: ben_plan_design_program_module.create_formula_result(
9438: p_validate => p_validate
9439: ,p_copy_entity_result_id => l_copy_entity_result_id
9440: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9441: ,p_formula_id => l_esh_rec.determination_rl

Line 9449: ben_plan_design_program_module.create_formula_result(

9445: ,p_effective_date => p_effective_date);
9446: end if;
9447:
9448: if (l_esh_rec.rounding_rl is not null) then
9449: ben_plan_design_program_module.create_formula_result(
9450: p_validate => p_validate
9451: ,p_copy_entity_result_id => l_copy_entity_result_id
9452: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9453: ,p_formula_id => l_esh_rec.rounding_rl

Line 9461: ben_plan_design_program_module.create_formula_result(

9457: ,p_effective_date => p_effective_date);
9458: end if;
9459:
9460: if (l_esh_rec.schedd_hrs_rl is not null) then
9461: ben_plan_design_program_module.create_formula_result(
9462: p_validate => p_validate
9463: ,p_copy_entity_result_id => l_copy_entity_result_id
9464: ,p_copy_entity_txn_id => p_copy_entity_txn_id
9465: ,p_formula_id => l_esh_rec.schedd_hrs_rl

Line 9491: open ben_plan_design_program_module.g_table_route('ESA');

9487: --
9488: for l_esa_rec in c_esa(l_parent_rec.elig_svc_area_prte_id,l_mirror_src_entity_result_id,'ESA' ) loop
9489: --
9490: l_table_route_id := null ;
9491: open ben_plan_design_program_module.g_table_route('ESA');
9492: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9493: close ben_plan_design_program_module.g_table_route ;
9494: --
9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id

Line 9492: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9488: for l_esa_rec in c_esa(l_parent_rec.elig_svc_area_prte_id,l_mirror_src_entity_result_id,'ESA' ) loop
9489: --
9490: l_table_route_id := null ;
9491: open ben_plan_design_program_module.g_table_route('ESA');
9492: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9493: close ben_plan_design_program_module.g_table_route ;
9494: --
9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id
9496: ,p_effective_date)

Line 9493: close ben_plan_design_program_module.g_table_route ;

9489: --
9490: l_table_route_id := null ;
9491: open ben_plan_design_program_module.g_table_route('ESA');
9492: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9493: close ben_plan_design_program_module.g_table_route ;
9494: --
9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id
9496: ,p_effective_date)
9497: || ben_plan_design_program_module.get_exclude_message(l_esa_rec.excld_flag);

Line 9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id

9491: open ben_plan_design_program_module.g_table_route('ESA');
9492: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9493: close ben_plan_design_program_module.g_table_route ;
9494: --
9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id
9496: ,p_effective_date)
9497: || ben_plan_design_program_module.get_exclude_message(l_esa_rec.excld_flag);
9498: --'Intersection';
9499: --

Line 9497: || ben_plan_design_program_module.get_exclude_message(l_esa_rec.excld_flag);

9493: close ben_plan_design_program_module.g_table_route ;
9494: --
9495: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_esa_rec.svc_area_id
9496: ,p_effective_date)
9497: || ben_plan_design_program_module.get_exclude_message(l_esa_rec.excld_flag);
9498: --'Intersection';
9499: --
9500: if p_effective_date between l_esa_rec.effective_start_date
9501: and l_esa_rec.effective_end_date then

Line 9610: open ben_plan_design_program_module.g_table_route('EWL');

9606: --
9607: for l_ewl_rec in c_ewl(l_parent_rec.elig_wk_loc_prte_id,l_mirror_src_entity_result_id,'EWL') loop
9608: --
9609: l_table_route_id := null ;
9610: open ben_plan_design_program_module.g_table_route('EWL');
9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9612: close ben_plan_design_program_module.g_table_route ;
9613: --
9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)

Line 9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9607: for l_ewl_rec in c_ewl(l_parent_rec.elig_wk_loc_prte_id,l_mirror_src_entity_result_id,'EWL') loop
9608: --
9609: l_table_route_id := null ;
9610: open ben_plan_design_program_module.g_table_route('EWL');
9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9612: close ben_plan_design_program_module.g_table_route ;
9613: --
9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)
9615: || ben_plan_design_program_module.get_exclude_message(l_ewl_rec.excld_flag);

Line 9612: close ben_plan_design_program_module.g_table_route ;

9608: --
9609: l_table_route_id := null ;
9610: open ben_plan_design_program_module.g_table_route('EWL');
9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9612: close ben_plan_design_program_module.g_table_route ;
9613: --
9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)
9615: || ben_plan_design_program_module.get_exclude_message(l_ewl_rec.excld_flag);
9616: --'Intersection';

Line 9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)

9610: open ben_plan_design_program_module.g_table_route('EWL');
9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9612: close ben_plan_design_program_module.g_table_route ;
9613: --
9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)
9615: || ben_plan_design_program_module.get_exclude_message(l_ewl_rec.excld_flag);
9616: --'Intersection';
9617: --
9618: if p_effective_date between l_ewl_rec.effective_start_date

Line 9615: || ben_plan_design_program_module.get_exclude_message(l_ewl_rec.excld_flag);

9611: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9612: close ben_plan_design_program_module.g_table_route ;
9613: --
9614: l_information5 := ben_plan_design_program_module.get_location_name(l_ewl_rec.location_id)
9615: || ben_plan_design_program_module.get_exclude_message(l_ewl_rec.excld_flag);
9616: --'Intersection';
9617: --
9618: if p_effective_date between l_ewl_rec.effective_start_date
9619: and l_ewl_rec.effective_end_date then

Line 9757: open ben_plan_design_program_module.g_table_route('ESP');

9753: --
9754: for l_esp_rec in c_esp(l_parent_rec.elig_sp_clng_prg_prte_id,l_mirror_src_entity_result_id,'ESP' ) loop
9755: --
9756: l_table_route_id := null ;
9757: open ben_plan_design_program_module.g_table_route('ESP');
9758: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9759: close ben_plan_design_program_module.g_table_route ;
9760: --
9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id

Line 9758: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9754: for l_esp_rec in c_esp(l_parent_rec.elig_sp_clng_prg_prte_id,l_mirror_src_entity_result_id,'ESP' ) loop
9755: --
9756: l_table_route_id := null ;
9757: open ben_plan_design_program_module.g_table_route('ESP');
9758: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9759: close ben_plan_design_program_module.g_table_route ;
9760: --
9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id
9762: ,p_effective_date)

Line 9759: close ben_plan_design_program_module.g_table_route ;

9755: --
9756: l_table_route_id := null ;
9757: open ben_plan_design_program_module.g_table_route('ESP');
9758: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9759: close ben_plan_design_program_module.g_table_route ;
9760: --
9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id
9762: ,p_effective_date)
9763: || ben_plan_design_program_module.get_exclude_message(l_esp_rec.excld_flag);

Line 9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id

9757: open ben_plan_design_program_module.g_table_route('ESP');
9758: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9759: close ben_plan_design_program_module.g_table_route ;
9760: --
9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id
9762: ,p_effective_date)
9763: || ben_plan_design_program_module.get_exclude_message(l_esp_rec.excld_flag);
9764: -- 'Intersection';
9765: --

Line 9763: || ben_plan_design_program_module.get_exclude_message(l_esp_rec.excld_flag);

9759: close ben_plan_design_program_module.g_table_route ;
9760: --
9761: l_information5 := ben_plan_design_program_module.get_sp_clng_step_name(l_esp_rec.special_ceiling_step_id
9762: ,p_effective_date)
9763: || ben_plan_design_program_module.get_exclude_message(l_esp_rec.excld_flag);
9764: -- 'Intersection';
9765: --
9766: if p_effective_date between l_esp_rec.effective_start_date
9767: and l_esp_rec.effective_end_date then

Line 9908: open ben_plan_design_program_module.g_table_route('EPS');

9904: --
9905: for l_eps_rec in c_eps(l_parent_rec.elig_pstn_prte_id,l_mirror_src_entity_result_id,'EPS' ) loop
9906: --
9907: l_table_route_id := null ;
9908: open ben_plan_design_program_module.g_table_route('EPS');
9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9910: close ben_plan_design_program_module.g_table_route ;
9911: --
9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)

Line 9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

9905: for l_eps_rec in c_eps(l_parent_rec.elig_pstn_prte_id,l_mirror_src_entity_result_id,'EPS' ) loop
9906: --
9907: l_table_route_id := null ;
9908: open ben_plan_design_program_module.g_table_route('EPS');
9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9910: close ben_plan_design_program_module.g_table_route ;
9911: --
9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)
9913: || ben_plan_design_program_module.get_exclude_message(l_eps_rec.excld_flag);

Line 9910: close ben_plan_design_program_module.g_table_route ;

9906: --
9907: l_table_route_id := null ;
9908: open ben_plan_design_program_module.g_table_route('EPS');
9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9910: close ben_plan_design_program_module.g_table_route ;
9911: --
9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)
9913: || ben_plan_design_program_module.get_exclude_message(l_eps_rec.excld_flag);
9914: --'Intersection';

Line 9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)

9908: open ben_plan_design_program_module.g_table_route('EPS');
9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9910: close ben_plan_design_program_module.g_table_route ;
9911: --
9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)
9913: || ben_plan_design_program_module.get_exclude_message(l_eps_rec.excld_flag);
9914: --'Intersection';
9915: --
9916: if p_effective_date between l_eps_rec.effective_start_date

Line 9913: || ben_plan_design_program_module.get_exclude_message(l_eps_rec.excld_flag);

9909: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9910: close ben_plan_design_program_module.g_table_route ;
9911: --
9912: l_information5 := ben_plan_design_program_module.get_position_name(l_eps_rec.position_id)
9913: || ben_plan_design_program_module.get_exclude_message(l_eps_rec.excld_flag);
9914: --'Intersection';
9915: --
9916: if p_effective_date between l_eps_rec.effective_start_date
9917: and l_eps_rec.effective_end_date then

Line 10056: open ben_plan_design_program_module.g_table_route('EPN');

10052: --
10053: for l_epn_rec in c_epn(l_parent_rec.elig_prbtn_perd_prte_id,l_mirror_src_entity_result_id,'EPN' ) loop
10054: --
10055: l_table_route_id := null ;
10056: open ben_plan_design_program_module.g_table_route('EPN');
10057: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10058: close ben_plan_design_program_module.g_table_route ;
10059: --
10060: l_information5 := l_epn_rec.probation_period ||' '||

Line 10057: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10053: for l_epn_rec in c_epn(l_parent_rec.elig_prbtn_perd_prte_id,l_mirror_src_entity_result_id,'EPN' ) loop
10054: --
10055: l_table_route_id := null ;
10056: open ben_plan_design_program_module.g_table_route('EPN');
10057: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10058: close ben_plan_design_program_module.g_table_route ;
10059: --
10060: l_information5 := l_epn_rec.probation_period ||' '||
10061: hr_general.decode_lookup('QUALIFYING_UNITS',l_epn_rec.probation_unit)

Line 10058: close ben_plan_design_program_module.g_table_route ;

10054: --
10055: l_table_route_id := null ;
10056: open ben_plan_design_program_module.g_table_route('EPN');
10057: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10058: close ben_plan_design_program_module.g_table_route ;
10059: --
10060: l_information5 := l_epn_rec.probation_period ||' '||
10061: hr_general.decode_lookup('QUALIFYING_UNITS',l_epn_rec.probation_unit)
10062: || ben_plan_design_program_module.get_exclude_message(l_epn_rec.excld_flag);

Line 10062: || ben_plan_design_program_module.get_exclude_message(l_epn_rec.excld_flag);

10058: close ben_plan_design_program_module.g_table_route ;
10059: --
10060: l_information5 := l_epn_rec.probation_period ||' '||
10061: hr_general.decode_lookup('QUALIFYING_UNITS',l_epn_rec.probation_unit)
10062: || ben_plan_design_program_module.get_exclude_message(l_epn_rec.excld_flag);
10063: --'Intersection';
10064: --
10065: if p_effective_date between l_epn_rec.effective_start_date
10066: and l_epn_rec.effective_end_date then

Line 10167: open ben_plan_design_program_module.g_table_route('EMP');

10163: --
10164: for l_emp_rec in c_emp(l_parent_rec.elig_mrtl_sts_prte_id,l_mirror_src_entity_result_id,'EMP' ) loop
10165: --
10166: l_table_route_id := null ;
10167: open ben_plan_design_program_module.g_table_route('EMP');
10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10169: close ben_plan_design_program_module.g_table_route ;
10170: --
10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)

Line 10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10164: for l_emp_rec in c_emp(l_parent_rec.elig_mrtl_sts_prte_id,l_mirror_src_entity_result_id,'EMP' ) loop
10165: --
10166: l_table_route_id := null ;
10167: open ben_plan_design_program_module.g_table_route('EMP');
10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10169: close ben_plan_design_program_module.g_table_route ;
10170: --
10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)
10172: || ben_plan_design_program_module.get_exclude_message(l_emp_rec.excld_flag);

Line 10169: close ben_plan_design_program_module.g_table_route ;

10165: --
10166: l_table_route_id := null ;
10167: open ben_plan_design_program_module.g_table_route('EMP');
10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10169: close ben_plan_design_program_module.g_table_route ;
10170: --
10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)
10172: || ben_plan_design_program_module.get_exclude_message(l_emp_rec.excld_flag);
10173: --'Intersection';

Line 10172: || ben_plan_design_program_module.get_exclude_message(l_emp_rec.excld_flag);

10168: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10169: close ben_plan_design_program_module.g_table_route ;
10170: --
10171: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_emp_rec.marital_status)
10172: || ben_plan_design_program_module.get_exclude_message(l_emp_rec.excld_flag);
10173: --'Intersection';
10174: --
10175: if p_effective_date between l_emp_rec.effective_start_date
10176: and l_emp_rec.effective_end_date then

Line 10274: open ben_plan_design_program_module.g_table_route('EGN');

10270: --
10271: for l_egn_rec in c_egn(l_parent_rec.elig_gndr_prte_id,l_mirror_src_entity_result_id,'EGN' ) loop
10272: --
10273: l_table_route_id := null ;
10274: open ben_plan_design_program_module.g_table_route('EGN');
10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10276: close ben_plan_design_program_module.g_table_route ;
10277: --
10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)

Line 10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10271: for l_egn_rec in c_egn(l_parent_rec.elig_gndr_prte_id,l_mirror_src_entity_result_id,'EGN' ) loop
10272: --
10273: l_table_route_id := null ;
10274: open ben_plan_design_program_module.g_table_route('EGN');
10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10276: close ben_plan_design_program_module.g_table_route ;
10277: --
10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)
10279: || ben_plan_design_program_module.get_exclude_message(l_egn_rec.excld_flag);

Line 10276: close ben_plan_design_program_module.g_table_route ;

10272: --
10273: l_table_route_id := null ;
10274: open ben_plan_design_program_module.g_table_route('EGN');
10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10276: close ben_plan_design_program_module.g_table_route ;
10277: --
10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)
10279: || ben_plan_design_program_module.get_exclude_message(l_egn_rec.excld_flag);
10280: --'Intersection';

Line 10279: || ben_plan_design_program_module.get_exclude_message(l_egn_rec.excld_flag);

10275: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10276: close ben_plan_design_program_module.g_table_route ;
10277: --
10278: l_information5 := hr_general.decode_lookup('SEX',l_egn_rec.sex)
10279: || ben_plan_design_program_module.get_exclude_message(l_egn_rec.excld_flag);
10280: --'Intersection';
10281: --
10282: if p_effective_date between l_egn_rec.effective_start_date
10283: and l_egn_rec.effective_end_date then

Line 10381: open ben_plan_design_program_module.g_table_route('EDR');

10377: --
10378: for l_edr_rec in c_edr(l_parent_rec.elig_dsblty_rsn_prte_id,l_mirror_src_entity_result_id,'EDR' ) loop
10379: --
10380: l_table_route_id := null ;
10381: open ben_plan_design_program_module.g_table_route('EDR');
10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10383: close ben_plan_design_program_module.g_table_route ;
10384: --
10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)

Line 10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10378: for l_edr_rec in c_edr(l_parent_rec.elig_dsblty_rsn_prte_id,l_mirror_src_entity_result_id,'EDR' ) loop
10379: --
10380: l_table_route_id := null ;
10381: open ben_plan_design_program_module.g_table_route('EDR');
10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10383: close ben_plan_design_program_module.g_table_route ;
10384: --
10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)
10386: || ben_plan_design_program_module.get_exclude_message(l_edr_rec.excld_flag);

Line 10383: close ben_plan_design_program_module.g_table_route ;

10379: --
10380: l_table_route_id := null ;
10381: open ben_plan_design_program_module.g_table_route('EDR');
10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10383: close ben_plan_design_program_module.g_table_route ;
10384: --
10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)
10386: || ben_plan_design_program_module.get_exclude_message(l_edr_rec.excld_flag);
10387: --'Intersection';

Line 10386: || ben_plan_design_program_module.get_exclude_message(l_edr_rec.excld_flag);

10382: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10383: close ben_plan_design_program_module.g_table_route ;
10384: --
10385: l_information5 := hr_general.decode_lookup('DISABILITY_REASON',l_edr_rec.reason)
10386: || ben_plan_design_program_module.get_exclude_message(l_edr_rec.excld_flag);
10387: --'Intersection';
10388: --
10389: if p_effective_date between l_edr_rec.effective_start_date
10390: and l_edr_rec.effective_end_date then

Line 10488: open ben_plan_design_program_module.g_table_route('EDD');

10484: --
10485: for l_edd_rec in c_edd(l_parent_rec.elig_dsblty_dgr_prte_id,l_mirror_src_entity_result_id,'EDD' ) loop
10486: --
10487: l_table_route_id := null ;
10488: open ben_plan_design_program_module.g_table_route('EDD');
10489: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10490: close ben_plan_design_program_module.g_table_route ;
10491: --
10492: l_information5 := l_edd_rec.degree

Line 10489: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10485: for l_edd_rec in c_edd(l_parent_rec.elig_dsblty_dgr_prte_id,l_mirror_src_entity_result_id,'EDD' ) loop
10486: --
10487: l_table_route_id := null ;
10488: open ben_plan_design_program_module.g_table_route('EDD');
10489: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10490: close ben_plan_design_program_module.g_table_route ;
10491: --
10492: l_information5 := l_edd_rec.degree
10493: ||ben_plan_design_program_module.get_exclude_message(l_edd_rec.excld_flag);

Line 10490: close ben_plan_design_program_module.g_table_route ;

10486: --
10487: l_table_route_id := null ;
10488: open ben_plan_design_program_module.g_table_route('EDD');
10489: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10490: close ben_plan_design_program_module.g_table_route ;
10491: --
10492: l_information5 := l_edd_rec.degree
10493: ||ben_plan_design_program_module.get_exclude_message(l_edd_rec.excld_flag);
10494: --'Intersection';

Line 10493: ||ben_plan_design_program_module.get_exclude_message(l_edd_rec.excld_flag);

10489: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10490: close ben_plan_design_program_module.g_table_route ;
10491: --
10492: l_information5 := l_edd_rec.degree
10493: ||ben_plan_design_program_module.get_exclude_message(l_edd_rec.excld_flag);
10494: --'Intersection';
10495: --
10496: if p_effective_date between l_edd_rec.effective_start_date
10497: and l_edd_rec.effective_end_date then

Line 10594: open ben_plan_design_program_module.g_table_route('EQT');

10590: --
10591: for l_eqt_rec in c_eqt(l_parent_rec.elig_qual_titl_prte_id,l_mirror_src_entity_result_id,'EQT' ) loop
10592: --
10593: l_table_route_id := null ;
10594: open ben_plan_design_program_module.g_table_route('EQT');
10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10596: close ben_plan_design_program_module.g_table_route ;
10597: --
10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)

Line 10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10591: for l_eqt_rec in c_eqt(l_parent_rec.elig_qual_titl_prte_id,l_mirror_src_entity_result_id,'EQT' ) loop
10592: --
10593: l_table_route_id := null ;
10594: open ben_plan_design_program_module.g_table_route('EQT');
10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10596: close ben_plan_design_program_module.g_table_route ;
10597: --
10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)
10599: || ben_plan_design_program_module.get_exclude_message(l_eqt_rec.excld_flag);

Line 10596: close ben_plan_design_program_module.g_table_route ;

10592: --
10593: l_table_route_id := null ;
10594: open ben_plan_design_program_module.g_table_route('EQT');
10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10596: close ben_plan_design_program_module.g_table_route ;
10597: --
10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)
10599: || ben_plan_design_program_module.get_exclude_message(l_eqt_rec.excld_flag);
10600: --'Intersection';

Line 10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)

10594: open ben_plan_design_program_module.g_table_route('EQT');
10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10596: close ben_plan_design_program_module.g_table_route ;
10597: --
10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)
10599: || ben_plan_design_program_module.get_exclude_message(l_eqt_rec.excld_flag);
10600: --'Intersection';
10601: --
10602: if p_effective_date between l_eqt_rec.effective_start_date

Line 10599: || ben_plan_design_program_module.get_exclude_message(l_eqt_rec.excld_flag);

10595: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10596: close ben_plan_design_program_module.g_table_route ;
10597: --
10598: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_eqt_rec.qualification_type_id)
10599: || ben_plan_design_program_module.get_exclude_message(l_eqt_rec.excld_flag);
10600: --'Intersection';
10601: --
10602: if p_effective_date between l_eqt_rec.effective_start_date
10603: and l_eqt_rec.effective_end_date then

Line 10730: open ben_plan_design_program_module.g_table_route('EST');

10726: --
10727: for l_est_rec in c_est(l_parent_rec.elig_suppl_role_prte_id,l_mirror_src_entity_result_id,'EST' ) loop
10728: --
10729: l_table_route_id := null ;
10730: open ben_plan_design_program_module.g_table_route('EST');
10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10732: close ben_plan_design_program_module.g_table_route ;
10733: --
10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)

Line 10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10727: for l_est_rec in c_est(l_parent_rec.elig_suppl_role_prte_id,l_mirror_src_entity_result_id,'EST' ) loop
10728: --
10729: l_table_route_id := null ;
10730: open ben_plan_design_program_module.g_table_route('EST');
10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10732: close ben_plan_design_program_module.g_table_route ;
10733: --
10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)
10735: || ben_plan_design_program_module.get_exclude_message(l_est_rec.excld_flag);

Line 10732: close ben_plan_design_program_module.g_table_route ;

10728: --
10729: l_table_route_id := null ;
10730: open ben_plan_design_program_module.g_table_route('EST');
10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10732: close ben_plan_design_program_module.g_table_route ;
10733: --
10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)
10735: || ben_plan_design_program_module.get_exclude_message(l_est_rec.excld_flag);
10736: --'Intersection';

Line 10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)

10730: open ben_plan_design_program_module.g_table_route('EST');
10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10732: close ben_plan_design_program_module.g_table_route ;
10733: --
10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)
10735: || ben_plan_design_program_module.get_exclude_message(l_est_rec.excld_flag);
10736: --'Intersection';
10737: --
10738: if p_effective_date between l_est_rec.effective_start_date

Line 10735: || ben_plan_design_program_module.get_exclude_message(l_est_rec.excld_flag);

10731: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10732: close ben_plan_design_program_module.g_table_route ;
10733: --
10734: l_information5 := ben_plan_design_program_module.get_job_name(l_est_rec.job_id)
10735: || ben_plan_design_program_module.get_exclude_message(l_est_rec.excld_flag);
10736: --'Intersection';
10737: --
10738: if p_effective_date between l_est_rec.effective_start_date
10739: and l_est_rec.effective_end_date then

Line 10889: open ben_plan_design_program_module.g_table_route('ECT');

10885: --
10886: for l_ect_rec in c_ect(l_parent_rec.elig_dsblty_ctg_prte_id,l_mirror_src_entity_result_id,'ECT' ) loop
10887: --
10888: l_table_route_id := null ;
10889: open ben_plan_design_program_module.g_table_route('ECT');
10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10891: close ben_plan_design_program_module.g_table_route ;
10892: --
10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)

Line 10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10886: for l_ect_rec in c_ect(l_parent_rec.elig_dsblty_ctg_prte_id,l_mirror_src_entity_result_id,'ECT' ) loop
10887: --
10888: l_table_route_id := null ;
10889: open ben_plan_design_program_module.g_table_route('ECT');
10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10891: close ben_plan_design_program_module.g_table_route ;
10892: --
10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)
10894: || ben_plan_design_program_module.get_exclude_message(l_ect_rec.excld_flag);

Line 10891: close ben_plan_design_program_module.g_table_route ;

10887: --
10888: l_table_route_id := null ;
10889: open ben_plan_design_program_module.g_table_route('ECT');
10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10891: close ben_plan_design_program_module.g_table_route ;
10892: --
10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)
10894: || ben_plan_design_program_module.get_exclude_message(l_ect_rec.excld_flag);
10895: --'Intersection';

Line 10894: || ben_plan_design_program_module.get_exclude_message(l_ect_rec.excld_flag);

10890: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10891: close ben_plan_design_program_module.g_table_route ;
10892: --
10893: l_information5 := hr_general.decode_lookup('DISABILITY_CATEGORY',l_ect_rec.category)
10894: || ben_plan_design_program_module.get_exclude_message(l_ect_rec.excld_flag);
10895: --'Intersection';
10896: --
10897: if p_effective_date between l_ect_rec.effective_start_date
10898: and l_ect_rec.effective_end_date then

Line 10996: open ben_plan_design_program_module.g_table_route('ERG');

10992: --
10993: for l_erg_rec in c_erg(l_parent_rec.elig_perf_rtng_prte_id,l_mirror_src_entity_result_id,'ERG' ) loop
10994: --
10995: l_table_route_id := null ;
10996: open ben_plan_design_program_module.g_table_route('ERG');
10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)

Line 10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

10993: for l_erg_rec in c_erg(l_parent_rec.elig_perf_rtng_prte_id,l_mirror_src_entity_result_id,'ERG' ) loop
10994: --
10995: l_table_route_id := null ;
10996: open ben_plan_design_program_module.g_table_route('ERG');
10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)
11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)

Line 10998: close ben_plan_design_program_module.g_table_route ;

10994: --
10995: l_table_route_id := null ;
10996: open ben_plan_design_program_module.g_table_route('ERG');
10997: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)
11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)
11002: || ben_plan_design_program_module.get_exclude_message(l_erg_rec.excld_flag);

Line 11002: || ben_plan_design_program_module.get_exclude_message(l_erg_rec.excld_flag);

10998: close ben_plan_design_program_module.g_table_route ;
10999: --
11000: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_erg_rec.event_type)
11001: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_erg_rec.perf_rtng_cd)
11002: || ben_plan_design_program_module.get_exclude_message(l_erg_rec.excld_flag);
11003: --'Intersection';
11004: --
11005: if p_effective_date between l_erg_rec.effective_start_date
11006: and l_erg_rec.effective_end_date then

Line 11103: open ben_plan_design_program_module.g_table_route('EQG');

11099: --
11100: for l_eqg_rec in c_eqg(l_parent_rec.elig_qua_in_gr_prte_id,l_mirror_src_entity_result_id,'EQG' ) loop
11101: --
11102: l_table_route_id := null ;
11103: open ben_plan_design_program_module.g_table_route('EQG');
11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11105: close ben_plan_design_program_module.g_table_route ;
11106: --
11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)

Line 11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11100: for l_eqg_rec in c_eqg(l_parent_rec.elig_qua_in_gr_prte_id,l_mirror_src_entity_result_id,'EQG' ) loop
11101: --
11102: l_table_route_id := null ;
11103: open ben_plan_design_program_module.g_table_route('EQG');
11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11105: close ben_plan_design_program_module.g_table_route ;
11106: --
11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)
11108: || ben_plan_design_program_module.get_exclude_message(l_eqg_rec.excld_flag);

Line 11105: close ben_plan_design_program_module.g_table_route ;

11101: --
11102: l_table_route_id := null ;
11103: open ben_plan_design_program_module.g_table_route('EQG');
11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11105: close ben_plan_design_program_module.g_table_route ;
11106: --
11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)
11108: || ben_plan_design_program_module.get_exclude_message(l_eqg_rec.excld_flag);
11109: -- 'Intersection';

Line 11108: || ben_plan_design_program_module.get_exclude_message(l_eqg_rec.excld_flag);

11104: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11105: close ben_plan_design_program_module.g_table_route ;
11106: --
11107: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_eqg_rec.quar_in_grade_cd)
11108: || ben_plan_design_program_module.get_exclude_message(l_eqg_rec.excld_flag);
11109: -- 'Intersection';
11110: --
11111: if p_effective_date between l_eqg_rec.effective_start_date
11112: and l_eqg_rec.effective_end_date then

Line 11209: open ben_plan_design_program_module.g_table_route('ETU');

11205: --
11206: for l_etu_rec in c_etu(l_parent_rec.elig_tbco_use_prte_id,l_mirror_src_entity_result_id,'ETU' ) loop
11207: --
11208: l_table_route_id := null ;
11209: open ben_plan_design_program_module.g_table_route('ETU');
11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11211: close ben_plan_design_program_module.g_table_route ;
11212: --
11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)

Line 11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11206: for l_etu_rec in c_etu(l_parent_rec.elig_tbco_use_prte_id,l_mirror_src_entity_result_id,'ETU' ) loop
11207: --
11208: l_table_route_id := null ;
11209: open ben_plan_design_program_module.g_table_route('ETU');
11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11211: close ben_plan_design_program_module.g_table_route ;
11212: --
11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)
11214: || ben_plan_design_program_module.get_exclude_message(l_etu_rec.excld_flag);

Line 11211: close ben_plan_design_program_module.g_table_route ;

11207: --
11208: l_table_route_id := null ;
11209: open ben_plan_design_program_module.g_table_route('ETU');
11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11211: close ben_plan_design_program_module.g_table_route ;
11212: --
11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)
11214: || ben_plan_design_program_module.get_exclude_message(l_etu_rec.excld_flag);
11215: --Intersection';

Line 11214: || ben_plan_design_program_module.get_exclude_message(l_etu_rec.excld_flag);

11210: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11211: close ben_plan_design_program_module.g_table_route ;
11212: --
11213: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_etu_rec.uses_tbco_flag)
11214: || ben_plan_design_program_module.get_exclude_message(l_etu_rec.excld_flag);
11215: --Intersection';
11216: --
11217: if p_effective_date between l_etu_rec.effective_start_date
11218: and l_etu_rec.effective_end_date then

Line 11314: open ben_plan_design_program_module.g_table_route('ETC');

11310: --
11311: for l_etc_rec in c_etc(l_parent_rec.elig_ttl_cvg_vol_prte_id,l_mirror_src_entity_result_id,'ETC' ) loop
11312: --
11313: l_table_route_id := null ;
11314: open ben_plan_design_program_module.g_table_route('ETC');
11315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11316: close ben_plan_design_program_module.g_table_route ;
11317: --
11318: l_information5 := l_etc_rec.mn_cvg_vol_amt || ' - ' ||l_etc_rec.mx_cvg_vol_amt

Line 11315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11311: for l_etc_rec in c_etc(l_parent_rec.elig_ttl_cvg_vol_prte_id,l_mirror_src_entity_result_id,'ETC' ) loop
11312: --
11313: l_table_route_id := null ;
11314: open ben_plan_design_program_module.g_table_route('ETC');
11315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11316: close ben_plan_design_program_module.g_table_route ;
11317: --
11318: l_information5 := l_etc_rec.mn_cvg_vol_amt || ' - ' ||l_etc_rec.mx_cvg_vol_amt
11319: || ben_plan_design_program_module.get_exclude_message(l_etc_rec.excld_flag);

Line 11316: close ben_plan_design_program_module.g_table_route ;

11312: --
11313: l_table_route_id := null ;
11314: open ben_plan_design_program_module.g_table_route('ETC');
11315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11316: close ben_plan_design_program_module.g_table_route ;
11317: --
11318: l_information5 := l_etc_rec.mn_cvg_vol_amt || ' - ' ||l_etc_rec.mx_cvg_vol_amt
11319: || ben_plan_design_program_module.get_exclude_message(l_etc_rec.excld_flag);
11320: --

Line 11319: || ben_plan_design_program_module.get_exclude_message(l_etc_rec.excld_flag);

11315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11316: close ben_plan_design_program_module.g_table_route ;
11317: --
11318: l_information5 := l_etc_rec.mn_cvg_vol_amt || ' - ' ||l_etc_rec.mx_cvg_vol_amt
11319: || ben_plan_design_program_module.get_exclude_message(l_etc_rec.excld_flag);
11320: --
11321: if p_effective_date between l_etc_rec.effective_start_date
11322: and l_etc_rec.effective_end_date then
11323: --

Line 11404: ben_plan_design_program_module.create_formula_result(

11400: end if;
11401: --
11402:
11403: if (l_etc_rec.cvg_vol_det_rl is not null) then
11404: ben_plan_design_program_module.create_formula_result(
11405: p_validate => p_validate
11406: ,p_copy_entity_result_id => l_copy_entity_result_id
11407: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11408: ,p_formula_id => l_etc_rec.cvg_vol_det_rl

Line 11434: open ben_plan_design_program_module.g_table_route('ETP');

11430: --
11431: for l_etp_rec in c_etp(l_parent_rec.elig_ttl_prtt_prte_id,l_mirror_src_entity_result_id,'ETP' ) loop
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('ETP');
11435: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11436: close ben_plan_design_program_module.g_table_route ;
11437: --
11438: l_information5 := l_etp_rec.mn_prtt_num ||' - '||l_etp_rec.mx_prtt_num

Line 11435: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11431: for l_etp_rec in c_etp(l_parent_rec.elig_ttl_prtt_prte_id,l_mirror_src_entity_result_id,'ETP' ) loop
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('ETP');
11435: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11436: close ben_plan_design_program_module.g_table_route ;
11437: --
11438: l_information5 := l_etp_rec.mn_prtt_num ||' - '||l_etp_rec.mx_prtt_num
11439: || ben_plan_design_program_module.get_exclude_message(l_etp_rec.excld_flag);

Line 11436: close ben_plan_design_program_module.g_table_route ;

11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('ETP');
11435: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11436: close ben_plan_design_program_module.g_table_route ;
11437: --
11438: l_information5 := l_etp_rec.mn_prtt_num ||' - '||l_etp_rec.mx_prtt_num
11439: || ben_plan_design_program_module.get_exclude_message(l_etp_rec.excld_flag);
11440: --

Line 11439: || ben_plan_design_program_module.get_exclude_message(l_etp_rec.excld_flag);

11435: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11436: close ben_plan_design_program_module.g_table_route ;
11437: --
11438: l_information5 := l_etp_rec.mn_prtt_num ||' - '||l_etp_rec.mx_prtt_num
11439: || ben_plan_design_program_module.get_exclude_message(l_etp_rec.excld_flag);
11440: --
11441: if p_effective_date between l_etp_rec.effective_start_date
11442: and l_etp_rec.effective_end_date then
11443: --

Line 11525: ben_plan_design_program_module.create_formula_result(

11521: end if;
11522: --
11523:
11524: if (l_etp_rec.prtt_det_rl is not null) then
11525: ben_plan_design_program_module.create_formula_result(
11526: p_validate => p_validate
11527: ,p_copy_entity_result_id => l_copy_entity_result_id
11528: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11529: ,p_formula_id => l_etp_rec.prtt_det_rl

Line 11555: open ben_plan_design_program_module.g_table_route('EDB');

11551: --
11552: for l_edb_rec in c_edb(l_parent_rec.elig_dsbld_prte_id,l_mirror_src_entity_result_id,'EDB' ) loop
11553: --
11554: l_table_route_id := null ;
11555: open ben_plan_design_program_module.g_table_route('EDB');
11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11557: close ben_plan_design_program_module.g_table_route ;
11558: --
11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)

Line 11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11552: for l_edb_rec in c_edb(l_parent_rec.elig_dsbld_prte_id,l_mirror_src_entity_result_id,'EDB' ) loop
11553: --
11554: l_table_route_id := null ;
11555: open ben_plan_design_program_module.g_table_route('EDB');
11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11557: close ben_plan_design_program_module.g_table_route ;
11558: --
11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)
11560: || ben_plan_design_program_module.get_exclude_message(l_edb_rec.excld_flag);

Line 11557: close ben_plan_design_program_module.g_table_route ;

11553: --
11554: l_table_route_id := null ;
11555: open ben_plan_design_program_module.g_table_route('EDB');
11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11557: close ben_plan_design_program_module.g_table_route ;
11558: --
11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)
11560: || ben_plan_design_program_module.get_exclude_message(l_edb_rec.excld_flag);
11561: -- 'Intersection';

Line 11560: || ben_plan_design_program_module.get_exclude_message(l_edb_rec.excld_flag);

11556: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11557: close ben_plan_design_program_module.g_table_route ;
11558: --
11559: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edb_rec.dsbld_cd)
11560: || ben_plan_design_program_module.get_exclude_message(l_edb_rec.excld_flag);
11561: -- 'Intersection';
11562: --
11563: if p_effective_date between l_edb_rec.effective_start_date
11564: and l_edb_rec.effective_end_date then

Line 11660: open ben_plan_design_program_module.g_table_route('EHC');

11656: --
11657: for l_ehc_rec in c_ehc(l_parent_rec.elig_hlth_cvg_prte_id,l_mirror_src_entity_result_id,'EHC' ) loop
11658: --
11659: l_table_route_id := null ;
11660: open ben_plan_design_program_module.g_table_route('EHC');
11661: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11662: close ben_plan_design_program_module.g_table_route ;
11663: --
11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id

Line 11661: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11657: for l_ehc_rec in c_ehc(l_parent_rec.elig_hlth_cvg_prte_id,l_mirror_src_entity_result_id,'EHC' ) loop
11658: --
11659: l_table_route_id := null ;
11660: open ben_plan_design_program_module.g_table_route('EHC');
11661: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11662: close ben_plan_design_program_module.g_table_route ;
11663: --
11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id
11665: ,l_ehc_rec.oipl_id

Line 11662: close ben_plan_design_program_module.g_table_route ;

11658: --
11659: l_table_route_id := null ;
11660: open ben_plan_design_program_module.g_table_route('EHC');
11661: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11662: close ben_plan_design_program_module.g_table_route ;
11663: --
11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id
11665: ,l_ehc_rec.oipl_id
11666: ,p_effective_date)

Line 11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id

11660: open ben_plan_design_program_module.g_table_route('EHC');
11661: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11662: close ben_plan_design_program_module.g_table_route ;
11663: --
11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id
11665: ,l_ehc_rec.oipl_id
11666: ,p_effective_date)
11667: || ben_plan_design_program_module.get_exclude_message(l_ehc_rec.excld_flag);
11668: --'Intersection';

Line 11667: || ben_plan_design_program_module.get_exclude_message(l_ehc_rec.excld_flag);

11663: --
11664: l_information5 := ben_plan_design_program_module.get_hlth_cvg_name(l_ehc_rec.pl_typ_opt_typ_id
11665: ,l_ehc_rec.oipl_id
11666: ,p_effective_date)
11667: || ben_plan_design_program_module.get_exclude_message(l_ehc_rec.excld_flag);
11668: --'Intersection';
11669:
11670: if p_effective_date between l_ehc_rec.effective_start_date
11671: and l_ehc_rec.effective_end_date then

Line 11764: open ben_plan_design_program_module.g_table_route('EOP');

11760: --
11761: for l_eop_rec in c_eop(l_parent_rec.elig_anthr_pl_prte_id,l_mirror_src_entity_result_id,'EOP' ) loop
11762: --
11763: l_table_route_id := null ;
11764: open ben_plan_design_program_module.g_table_route('EOP');
11765: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11766: close ben_plan_design_program_module.g_table_route ;
11767: --
11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id

Line 11765: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11761: for l_eop_rec in c_eop(l_parent_rec.elig_anthr_pl_prte_id,l_mirror_src_entity_result_id,'EOP' ) loop
11762: --
11763: l_table_route_id := null ;
11764: open ben_plan_design_program_module.g_table_route('EOP');
11765: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11766: close ben_plan_design_program_module.g_table_route ;
11767: --
11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id
11769: ,p_effective_date)

Line 11766: close ben_plan_design_program_module.g_table_route ;

11762: --
11763: l_table_route_id := null ;
11764: open ben_plan_design_program_module.g_table_route('EOP');
11765: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11766: close ben_plan_design_program_module.g_table_route ;
11767: --
11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id
11769: ,p_effective_date)
11770: || ben_plan_design_program_module.get_exclude_message(l_eop_rec.excld_flag);

Line 11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id

11764: open ben_plan_design_program_module.g_table_route('EOP');
11765: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11766: close ben_plan_design_program_module.g_table_route ;
11767: --
11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id
11769: ,p_effective_date)
11770: || ben_plan_design_program_module.get_exclude_message(l_eop_rec.excld_flag);
11771: --'Intersection';
11772:

Line 11770: || ben_plan_design_program_module.get_exclude_message(l_eop_rec.excld_flag);

11766: close ben_plan_design_program_module.g_table_route ;
11767: --
11768: l_information5 := ben_plan_design_program_module.get_pl_name(l_eop_rec.pl_id
11769: ,p_effective_date)
11770: || ben_plan_design_program_module.get_exclude_message(l_eop_rec.excld_flag);
11771: --'Intersection';
11772:
11773: if p_effective_date between l_eop_rec.effective_start_date
11774: and l_eop_rec.effective_end_date then

Line 11874: open ben_plan_design_program_module.g_table_route('ECV');

11870: loop
11871: --
11872: l_table_route_id := null ;
11873: --
11874: open ben_plan_design_program_module.g_table_route('ECV');
11875: --
11876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11877: --
11878: close ben_plan_design_program_module.g_table_route ;

Line 11876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

11872: l_table_route_id := null ;
11873: --
11874: open ben_plan_design_program_module.g_table_route('ECV');
11875: --
11876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11877: --
11878: close ben_plan_design_program_module.g_table_route ;
11879: --
11880: l_information5 := ben_plan_design_program_module.get_eligy_criteria_name (l_ecv_rec.eligy_criteria_id ) ||

Line 11878: close ben_plan_design_program_module.g_table_route ;

11874: open ben_plan_design_program_module.g_table_route('ECV');
11875: --
11876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11877: --
11878: close ben_plan_design_program_module.g_table_route ;
11879: --
11880: l_information5 := ben_plan_design_program_module.get_eligy_criteria_name (l_ecv_rec.eligy_criteria_id ) ||
11881: ben_plan_design_program_module.get_exclude_message(l_ecv_rec.excld_flag);
11882: --

Line 11880: l_information5 := ben_plan_design_program_module.get_eligy_criteria_name (l_ecv_rec.eligy_criteria_id ) ||

11876: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11877: --
11878: close ben_plan_design_program_module.g_table_route ;
11879: --
11880: l_information5 := ben_plan_design_program_module.get_eligy_criteria_name (l_ecv_rec.eligy_criteria_id ) ||
11881: ben_plan_design_program_module.get_exclude_message(l_ecv_rec.excld_flag);
11882: --
11883: if p_effective_date between l_ecv_rec.effective_start_date
11884: and l_ecv_rec.effective_end_date

Line 11881: ben_plan_design_program_module.get_exclude_message(l_ecv_rec.excld_flag);

11877: --
11878: close ben_plan_design_program_module.g_table_route ;
11879: --
11880: l_information5 := ben_plan_design_program_module.get_eligy_criteria_name (l_ecv_rec.eligy_criteria_id ) ||
11881: ben_plan_design_program_module.get_exclude_message(l_ecv_rec.excld_flag);
11882: --
11883: if p_effective_date between l_ecv_rec.effective_start_date
11884: and l_ecv_rec.effective_end_date
11885: then

Line 12063: open ben_plan_design_program_module.g_table_route('EGL');

12059: loop
12060: --
12061: l_egl_table_route_id := null ;
12062: --
12063: open ben_plan_design_program_module.g_table_route('EGL');
12064: --
12065: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
12066: --
12067: close ben_plan_design_program_module.g_table_route ;

Line 12065: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;

12061: l_egl_table_route_id := null ;
12062: --
12063: open ben_plan_design_program_module.g_table_route('EGL');
12064: --
12065: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
12066: --
12067: close ben_plan_design_program_module.g_table_route ;
12068: --
12069: l_egl_result_type_cd := 'NO DISPLAY';

Line 12067: close ben_plan_design_program_module.g_table_route ;

12063: open ben_plan_design_program_module.g_table_route('EGL');
12064: --
12065: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
12066: --
12067: close ben_plan_design_program_module.g_table_route ;
12068: --
12069: l_egl_result_type_cd := 'NO DISPLAY';
12070: --
12071: l_egl_copy_entity_result_id := null;

Line 12168: ben_plan_design_program_module.create_formula_result

12164: --
12165: if l_egl_rec.access_calc_rule is not null
12166: then
12167: --
12168: ben_plan_design_program_module.create_formula_result
12169: (
12170: p_validate => 0,
12171: p_copy_entity_result_id => l_egl_copy_entity_result_id,
12172: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 12627: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12623: l_number_of_copies number(15);
12624:
12625: begin
12626:
12627: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12628: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12629: end if;
12630:
12631: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 12628: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

12624:
12625: begin
12626:
12627: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12628: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12629: end if;
12630:
12631: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12632: open c_object_exists(p_dpnt_cvg_eligy_prfl_id,'DCE');

Line 12631: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

12627: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12628: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
12629: end if;
12630:
12631: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
12632: open c_object_exists(p_dpnt_cvg_eligy_prfl_id,'DCE');
12633: fetch c_object_exists into l_dummy;
12634: if c_object_exists%found then
12635: close c_object_exists;

Line 12652: open ben_plan_design_program_module.g_table_route('DCE');

12648: --
12649: for l_dce_rec in c_dce(p_dpnt_cvg_eligy_prfl_id,l_mirror_src_entity_result_id,'DCE' ) loop
12650: --
12651: l_table_route_id := null ;
12652: open ben_plan_design_program_module.g_table_route('DCE');
12653: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12654: close ben_plan_design_program_module.g_table_route ;
12655: --
12656: l_information5 := l_dce_rec.name; --'Intersection';

Line 12653: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12649: for l_dce_rec in c_dce(p_dpnt_cvg_eligy_prfl_id,l_mirror_src_entity_result_id,'DCE' ) loop
12650: --
12651: l_table_route_id := null ;
12652: open ben_plan_design_program_module.g_table_route('DCE');
12653: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12654: close ben_plan_design_program_module.g_table_route ;
12655: --
12656: l_information5 := l_dce_rec.name; --'Intersection';
12657: --

Line 12654: close ben_plan_design_program_module.g_table_route ;

12650: --
12651: l_table_route_id := null ;
12652: open ben_plan_design_program_module.g_table_route('DCE');
12653: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12654: close ben_plan_design_program_module.g_table_route ;
12655: --
12656: l_information5 := l_dce_rec.name; --'Intersection';
12657: --
12658: if p_effective_date between l_dce_rec.effective_start_date

Line 12746: ben_plan_design_program_module.create_formula_result(

12742: end if;
12743: --
12744: --
12745: if (l_dce_rec.dpnt_cvg_elig_det_rl is not null) then
12746: ben_plan_design_program_module.create_formula_result(
12747: p_validate => p_validate
12748: ,p_copy_entity_result_id => l_copy_entity_result_id
12749: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12750: ,p_formula_id => l_dce_rec.dpnt_cvg_elig_det_rl

Line 12777: open ben_plan_design_program_module.g_table_route('DCR');

12773: --
12774: for l_dcr_rec in c_dcr(l_parent_rec.dpnt_cvg_rqd_rlshp_id,l_mirror_src_entity_result_id,'DCR' ) loop
12775: --
12776: l_table_route_id := null ;
12777: open ben_plan_design_program_module.g_table_route('DCR');
12778: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12779: close ben_plan_design_program_module.g_table_route ;
12780: --
12781: l_information5 := hr_general.decode_lookup('CONTACT',l_dcr_rec.per_relshp_typ_cd);

Line 12778: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12774: for l_dcr_rec in c_dcr(l_parent_rec.dpnt_cvg_rqd_rlshp_id,l_mirror_src_entity_result_id,'DCR' ) loop
12775: --
12776: l_table_route_id := null ;
12777: open ben_plan_design_program_module.g_table_route('DCR');
12778: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12779: close ben_plan_design_program_module.g_table_route ;
12780: --
12781: l_information5 := hr_general.decode_lookup('CONTACT',l_dcr_rec.per_relshp_typ_cd);
12782: --'Intersection';

Line 12779: close ben_plan_design_program_module.g_table_route ;

12775: --
12776: l_table_route_id := null ;
12777: open ben_plan_design_program_module.g_table_route('DCR');
12778: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12779: close ben_plan_design_program_module.g_table_route ;
12780: --
12781: l_information5 := hr_general.decode_lookup('CONTACT',l_dcr_rec.per_relshp_typ_cd);
12782: --'Intersection';
12783: --

Line 12863: ben_plan_design_program_module.create_formula_result(

12859: l_out_dcr_result_id := l_copy_entity_result_id ;
12860: end if;
12861: --
12862: if (l_dcr_rec.cvg_strt_dt_rl is not null) then
12863: ben_plan_design_program_module.create_formula_result(
12864: p_validate => p_validate
12865: ,p_copy_entity_result_id => l_copy_entity_result_id
12866: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12867: ,p_formula_id => l_dcr_rec.cvg_strt_dt_rl

Line 12875: ben_plan_design_program_module.create_formula_result(

12871: ,p_effective_date => p_effective_date);
12872: end if;
12873:
12874: if (l_dcr_rec.cvg_thru_dt_rl is not null) then
12875: ben_plan_design_program_module.create_formula_result(
12876: p_validate => p_validate
12877: ,p_copy_entity_result_id => l_copy_entity_result_id
12878: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12879: ,p_formula_id => l_dcr_rec.cvg_thru_dt_rl

Line 12906: open ben_plan_design_program_module.g_table_route('DPC');

12902: --
12903: for l_dpc_rec in c_dpc(l_parent_rec.dpnt_cvrd_anthr_pl_cvg_id,l_mirror_src_entity_result_id,'DPC' ) loop
12904: --
12905: l_table_route_id := null ;
12906: open ben_plan_design_program_module.g_table_route('DPC');
12907: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12908: close ben_plan_design_program_module.g_table_route ;
12909: --
12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id

Line 12907: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

12903: for l_dpc_rec in c_dpc(l_parent_rec.dpnt_cvrd_anthr_pl_cvg_id,l_mirror_src_entity_result_id,'DPC' ) loop
12904: --
12905: l_table_route_id := null ;
12906: open ben_plan_design_program_module.g_table_route('DPC');
12907: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12908: close ben_plan_design_program_module.g_table_route ;
12909: --
12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id
12911: ,p_effective_date)

Line 12908: close ben_plan_design_program_module.g_table_route ;

12904: --
12905: l_table_route_id := null ;
12906: open ben_plan_design_program_module.g_table_route('DPC');
12907: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12908: close ben_plan_design_program_module.g_table_route ;
12909: --
12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id
12911: ,p_effective_date)
12912: || ben_plan_design_program_module.get_exclude_message(l_dpc_rec.excld_flag);

Line 12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id

12906: open ben_plan_design_program_module.g_table_route('DPC');
12907: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12908: close ben_plan_design_program_module.g_table_route ;
12909: --
12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id
12911: ,p_effective_date)
12912: || ben_plan_design_program_module.get_exclude_message(l_dpc_rec.excld_flag);
12913: --'Intersection';
12914: --

Line 12912: || ben_plan_design_program_module.get_exclude_message(l_dpc_rec.excld_flag);

12908: close ben_plan_design_program_module.g_table_route ;
12909: --
12910: l_information5 := ben_plan_design_program_module.get_pl_name(l_dpc_rec.pl_id
12911: ,p_effective_date)
12912: || ben_plan_design_program_module.get_exclude_message(l_dpc_rec.excld_flag);
12913: --'Intersection';
12914: --
12915: if p_effective_date between l_dpc_rec.effective_start_date
12916: and l_dpc_rec.effective_end_date then

Line 13011: open ben_plan_design_program_module.g_table_route('DEC');

13007: --
13008: for l_dec_rec in c_dec(l_parent_rec.dsgntr_enrld_cvg_id,l_mirror_src_entity_result_id,'DEC' ) loop
13009: --
13010: l_table_route_id := null ;
13011: open ben_plan_design_program_module.g_table_route('DEC');
13012: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13013: close ben_plan_design_program_module.g_table_route ;
13014: --
13015: l_information5 := hr_general.decode_lookup('YES_NO',l_dec_rec.dsgntr_crntly_enrld_flag);

Line 13012: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13008: for l_dec_rec in c_dec(l_parent_rec.dsgntr_enrld_cvg_id,l_mirror_src_entity_result_id,'DEC' ) loop
13009: --
13010: l_table_route_id := null ;
13011: open ben_plan_design_program_module.g_table_route('DEC');
13012: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13013: close ben_plan_design_program_module.g_table_route ;
13014: --
13015: l_information5 := hr_general.decode_lookup('YES_NO',l_dec_rec.dsgntr_crntly_enrld_flag);
13016: --'Intersection';

Line 13013: close ben_plan_design_program_module.g_table_route ;

13009: --
13010: l_table_route_id := null ;
13011: open ben_plan_design_program_module.g_table_route('DEC');
13012: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13013: close ben_plan_design_program_module.g_table_route ;
13014: --
13015: l_information5 := hr_general.decode_lookup('YES_NO',l_dec_rec.dsgntr_crntly_enrld_flag);
13016: --'Intersection';
13017: --

Line 13111: open ben_plan_design_program_module.g_table_route('EAC');

13107: --
13108: for l_eac_rec in c_eac(l_parent_rec.elig_age_cvg_id,l_mirror_src_entity_result_id,'EAC' ) loop
13109: --
13110: l_table_route_id := null ;
13111: open ben_plan_design_program_module.g_table_route('EAC');
13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13113: close ben_plan_design_program_module.g_table_route ;
13114: --
13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)

Line 13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13108: for l_eac_rec in c_eac(l_parent_rec.elig_age_cvg_id,l_mirror_src_entity_result_id,'EAC' ) loop
13109: --
13110: l_table_route_id := null ;
13111: open ben_plan_design_program_module.g_table_route('EAC');
13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13113: close ben_plan_design_program_module.g_table_route ;
13114: --
13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)
13116: || ben_plan_design_program_module.get_exclude_message(l_eac_rec.excld_flag);

Line 13113: close ben_plan_design_program_module.g_table_route ;

13109: --
13110: l_table_route_id := null ;
13111: open ben_plan_design_program_module.g_table_route('EAC');
13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13113: close ben_plan_design_program_module.g_table_route ;
13114: --
13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)
13116: || ben_plan_design_program_module.get_exclude_message(l_eac_rec.excld_flag);
13117: --'Intersection';

Line 13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)

13111: open ben_plan_design_program_module.g_table_route('EAC');
13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13113: close ben_plan_design_program_module.g_table_route ;
13114: --
13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)
13116: || ben_plan_design_program_module.get_exclude_message(l_eac_rec.excld_flag);
13117: --'Intersection';
13118: --
13119: if p_effective_date between l_eac_rec.effective_start_date

Line 13116: || ben_plan_design_program_module.get_exclude_message(l_eac_rec.excld_flag);

13112: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13113: close ben_plan_design_program_module.g_table_route ;
13114: --
13115: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_eac_rec.age_fctr_id)
13116: || ben_plan_design_program_module.get_exclude_message(l_eac_rec.excld_flag);
13117: --'Intersection';
13118: --
13119: if p_effective_date between l_eac_rec.effective_start_date
13120: and l_eac_rec.effective_end_date then

Line 13199: ben_plan_design_program_module.create_formula_result(

13195: l_out_eac_result_id := l_copy_entity_result_id ;
13196: end if;
13197: --
13198: if (l_eac_rec.cvg_strt_rl is not null) then
13199: ben_plan_design_program_module.create_formula_result(
13200: p_validate => p_validate
13201: ,p_copy_entity_result_id => l_copy_entity_result_id
13202: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13203: ,p_formula_id => l_eac_rec.cvg_strt_rl

Line 13211: ben_plan_design_program_module.create_formula_result(

13207: ,p_effective_date => p_effective_date);
13208: end if;
13209:
13210: if (l_eac_rec.cvg_thru_rl is not null) then
13211: ben_plan_design_program_module.create_formula_result(
13212: p_validate => p_validate
13213: ,p_copy_entity_result_id => l_copy_entity_result_id
13214: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13215: ,p_formula_id => l_eac_rec.cvg_thru_rl

Line 13259: open ben_plan_design_program_module.g_table_route('EDC');

13255: --
13256: for l_edc_rec in c_edc(l_parent_rec.elig_dsbld_stat_cvg_id,l_mirror_src_entity_result_id,'EDC' ) loop
13257: --
13258: l_table_route_id := null ;
13259: open ben_plan_design_program_module.g_table_route('EDC');
13260: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13261: close ben_plan_design_program_module.g_table_route ;
13262: --
13263: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edc_rec.dsbld_cd);

Line 13260: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13256: for l_edc_rec in c_edc(l_parent_rec.elig_dsbld_stat_cvg_id,l_mirror_src_entity_result_id,'EDC' ) loop
13257: --
13258: l_table_route_id := null ;
13259: open ben_plan_design_program_module.g_table_route('EDC');
13260: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13261: close ben_plan_design_program_module.g_table_route ;
13262: --
13263: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edc_rec.dsbld_cd);
13264: --'Intersection';

Line 13261: close ben_plan_design_program_module.g_table_route ;

13257: --
13258: l_table_route_id := null ;
13259: open ben_plan_design_program_module.g_table_route('EDC');
13260: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13261: close ben_plan_design_program_module.g_table_route ;
13262: --
13263: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_edc_rec.dsbld_cd);
13264: --'Intersection';
13265: --

Line 13345: ben_plan_design_program_module.create_formula_result(

13341: l_out_edc_result_id := l_copy_entity_result_id ;
13342: end if;
13343: --
13344: if (l_edc_rec.cvg_strt_rl is not null) then
13345: ben_plan_design_program_module.create_formula_result(
13346: p_validate => p_validate
13347: ,p_copy_entity_result_id => l_copy_entity_result_id
13348: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13349: ,p_formula_id => l_edc_rec.cvg_strt_rl

Line 13357: ben_plan_design_program_module.create_formula_result(

13353: ,p_effective_date => p_effective_date);
13354: end if;
13355: --
13356: if (l_edc_rec.cvg_thru_rl is not null) then
13357: ben_plan_design_program_module.create_formula_result(
13358: p_validate => p_validate
13359: ,p_copy_entity_result_id => l_copy_entity_result_id
13360: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13361: ,p_formula_id => l_edc_rec.cvg_thru_rl

Line 13387: open ben_plan_design_program_module.g_table_route('EMC');

13383: --
13384: for l_emc_rec in c_emc(l_parent_rec.elig_mltry_stat_cvg_id,l_mirror_src_entity_result_id,'EMC' ) loop
13385: --
13386: l_table_route_id := null ;
13387: open ben_plan_design_program_module.g_table_route('EMC');
13388: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13389: close ben_plan_design_program_module.g_table_route ;
13390: --
13391: l_information5 := hr_general.decode_lookup('YES_NO',l_emc_rec.mltry_stat_cd);

Line 13388: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13384: for l_emc_rec in c_emc(l_parent_rec.elig_mltry_stat_cvg_id,l_mirror_src_entity_result_id,'EMC' ) loop
13385: --
13386: l_table_route_id := null ;
13387: open ben_plan_design_program_module.g_table_route('EMC');
13388: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13389: close ben_plan_design_program_module.g_table_route ;
13390: --
13391: l_information5 := hr_general.decode_lookup('YES_NO',l_emc_rec.mltry_stat_cd);
13392: --'Intersection';

Line 13389: close ben_plan_design_program_module.g_table_route ;

13385: --
13386: l_table_route_id := null ;
13387: open ben_plan_design_program_module.g_table_route('EMC');
13388: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13389: close ben_plan_design_program_module.g_table_route ;
13390: --
13391: l_information5 := hr_general.decode_lookup('YES_NO',l_emc_rec.mltry_stat_cd);
13392: --'Intersection';
13393: --

Line 13473: ben_plan_design_program_module.create_formula_result(

13469: l_out_emc_result_id := l_copy_entity_result_id ;
13470: end if;
13471: --
13472: if (l_emc_rec.cvg_strt_rl is not null) then
13473: ben_plan_design_program_module.create_formula_result(
13474: p_validate => p_validate
13475: ,p_copy_entity_result_id => l_copy_entity_result_id
13476: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13477: ,p_formula_id => l_emc_rec.cvg_strt_rl

Line 13485: ben_plan_design_program_module.create_formula_result(

13481: ,p_effective_date => p_effective_date);
13482: end if;
13483:
13484: if (l_emc_rec.cvg_thru_rl is not null) then
13485: ben_plan_design_program_module.create_formula_result(
13486: p_validate => p_validate
13487: ,p_copy_entity_result_id => l_copy_entity_result_id
13488: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13489: ,p_formula_id => l_emc_rec.cvg_thru_rl

Line 13517: open ben_plan_design_program_module.g_table_route('EMS');

13513: --
13514: for l_ems_rec in c_ems(l_parent_rec.elig_mrtl_stat_cvg_id,l_mirror_src_entity_result_id,'EMS' ) loop
13515: --
13516: l_table_route_id := null ;
13517: open ben_plan_design_program_module.g_table_route('EMS');
13518: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13519: close ben_plan_design_program_module.g_table_route ;
13520: --
13521: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_ems_rec.mrtl_stat_cd);

Line 13518: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13514: for l_ems_rec in c_ems(l_parent_rec.elig_mrtl_stat_cvg_id,l_mirror_src_entity_result_id,'EMS' ) loop
13515: --
13516: l_table_route_id := null ;
13517: open ben_plan_design_program_module.g_table_route('EMS');
13518: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13519: close ben_plan_design_program_module.g_table_route ;
13520: --
13521: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_ems_rec.mrtl_stat_cd);
13522: --'Intersection';

Line 13519: close ben_plan_design_program_module.g_table_route ;

13515: --
13516: l_table_route_id := null ;
13517: open ben_plan_design_program_module.g_table_route('EMS');
13518: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13519: close ben_plan_design_program_module.g_table_route ;
13520: --
13521: l_information5 := hr_general.decode_lookup('MAR_STATUS',l_ems_rec.mrtl_stat_cd);
13522: --'Intersection';
13523: --

Line 13603: ben_plan_design_program_module.create_formula_result(

13599: l_out_ems_result_id := l_copy_entity_result_id ;
13600: end if;
13601: --
13602: if (l_ems_rec.cvg_strt_rl is not null) then
13603: ben_plan_design_program_module.create_formula_result(
13604: p_validate => p_validate
13605: ,p_copy_entity_result_id => l_copy_entity_result_id
13606: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13607: ,p_formula_id => l_ems_rec.cvg_strt_rl

Line 13615: ben_plan_design_program_module.create_formula_result(

13611: ,p_effective_date => p_effective_date);
13612: end if;
13613:
13614: if (l_ems_rec.cvg_thru_rl is not null) then
13615: ben_plan_design_program_module.create_formula_result(
13616: p_validate => p_validate
13617: ,p_copy_entity_result_id => l_copy_entity_result_id
13618: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13619: ,p_formula_id => l_ems_rec.cvg_thru_rl

Line 13646: open ben_plan_design_program_module.g_table_route('EPL');

13642: --
13643: for l_epl_rec in c_epl(l_parent_rec.elig_pstl_cd_r_rng_cvg_id,l_mirror_src_entity_result_id,'EPL' ) loop
13644: --
13645: l_table_route_id := null ;
13646: open ben_plan_design_program_module.g_table_route('EPL');
13647: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13648: close ben_plan_design_program_module.g_table_route ;
13649: --
13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id

Line 13647: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13643: for l_epl_rec in c_epl(l_parent_rec.elig_pstl_cd_r_rng_cvg_id,l_mirror_src_entity_result_id,'EPL' ) loop
13644: --
13645: l_table_route_id := null ;
13646: open ben_plan_design_program_module.g_table_route('EPL');
13647: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13648: close ben_plan_design_program_module.g_table_route ;
13649: --
13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id
13651: ,p_effective_date)

Line 13648: close ben_plan_design_program_module.g_table_route ;

13644: --
13645: l_table_route_id := null ;
13646: open ben_plan_design_program_module.g_table_route('EPL');
13647: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13648: close ben_plan_design_program_module.g_table_route ;
13649: --
13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id
13651: ,p_effective_date)
13652: || ben_plan_design_program_module.get_exclude_message(l_epl_rec.excld_flag);

Line 13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id

13646: open ben_plan_design_program_module.g_table_route('EPL');
13647: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13648: close ben_plan_design_program_module.g_table_route ;
13649: --
13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id
13651: ,p_effective_date)
13652: || ben_plan_design_program_module.get_exclude_message(l_epl_rec.excld_flag);
13653: --'Intersection';
13654: --

Line 13652: || ben_plan_design_program_module.get_exclude_message(l_epl_rec.excld_flag);

13648: close ben_plan_design_program_module.g_table_route ;
13649: --
13650: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_epl_rec.pstl_zip_rng_id
13651: ,p_effective_date)
13652: || ben_plan_design_program_module.get_exclude_message(l_epl_rec.excld_flag);
13653: --'Intersection';
13654: --
13655: if p_effective_date between l_epl_rec.effective_start_date
13656: and l_epl_rec.effective_end_date then

Line 13763: open ben_plan_design_program_module.g_table_route('ESC');

13759: --
13760: for l_esc_rec in c_esc(l_parent_rec.elig_stdnt_stat_cvg_id,l_mirror_src_entity_result_id,'ESC' ) loop
13761: --
13762: l_table_route_id := null ;
13763: open ben_plan_design_program_module.g_table_route('ESC');
13764: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13765: close ben_plan_design_program_module.g_table_route ;
13766: --
13767: l_information5 := hr_general.decode_lookup('STUDENT_STATUS',l_esc_rec.stdnt_stat_cd);

Line 13764: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;

13760: for l_esc_rec in c_esc(l_parent_rec.elig_stdnt_stat_cvg_id,l_mirror_src_entity_result_id,'ESC' ) loop
13761: --
13762: l_table_route_id := null ;
13763: open ben_plan_design_program_module.g_table_route('ESC');
13764: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13765: close ben_plan_design_program_module.g_table_route ;
13766: --
13767: l_information5 := hr_general.decode_lookup('STUDENT_STATUS',l_esc_rec.stdnt_stat_cd);
13768: --'Intersection';

Line 13765: close ben_plan_design_program_module.g_table_route ;

13761: --
13762: l_table_route_id := null ;
13763: open ben_plan_design_program_module.g_table_route('ESC');
13764: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13765: close ben_plan_design_program_module.g_table_route ;
13766: --
13767: l_information5 := hr_general.decode_lookup('STUDENT_STATUS',l_esc_rec.stdnt_stat_cd);
13768: --'Intersection';
13769: --

Line 13849: ben_plan_design_program_module.create_formula_result(

13845: l_out_esc_result_id := l_copy_entity_result_id ;
13846: end if;
13847: --
13848: if (l_esc_rec.cvg_strt_rl is not null) then
13849: ben_plan_design_program_module.create_formula_result(
13850: p_validate => p_validate
13851: ,p_copy_entity_result_id => l_copy_entity_result_id
13852: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13853: ,p_formula_id => l_esc_rec.cvg_strt_rl

Line 13861: ben_plan_design_program_module.create_formula_result(

13857: ,p_effective_date => p_effective_date);
13858: end if;
13859:
13860: if (l_esc_rec.cvg_thru_rl is not null) then
13861: ben_plan_design_program_module.create_formula_result(
13862: p_validate => p_validate
13863: ,p_copy_entity_result_id => l_copy_entity_result_id
13864: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13865: ,p_formula_id => l_esc_rec.cvg_thru_rl

Line 13968: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

13964: l_number_of_copies number(15);
13965: --
13966: begin
13967: --
13968: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
13969: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
13970: end if;
13971: --
13972: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

Line 13969: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;

13965: --
13966: begin
13967: --
13968: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
13969: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
13970: end if;
13971: --
13972: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
13973: open c_object_exists(p_eligy_criteria_id,'EGL');

Line 13972: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then

13968: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
13969: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
13970: end if;
13971: --
13972: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
13973: open c_object_exists(p_eligy_criteria_id,'EGL');
13974: fetch c_object_exists into l_dummy;
13975: if c_object_exists%found then
13976: close c_object_exists;

Line 14000: open ben_plan_design_program_module.g_table_route('EGL');

13996: loop
13997: --
13998: l_egl_table_route_id := null ;
13999: --
14000: open ben_plan_design_program_module.g_table_route('EGL');
14001: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
14002: close ben_plan_design_program_module.g_table_route ;
14003: --
14004: l_egl_result_type_cd := 'NO DISPLAY';

Line 14001: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;

13997: --
13998: l_egl_table_route_id := null ;
13999: --
14000: open ben_plan_design_program_module.g_table_route('EGL');
14001: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
14002: close ben_plan_design_program_module.g_table_route ;
14003: --
14004: l_egl_result_type_cd := 'NO DISPLAY';
14005: --

Line 14002: close ben_plan_design_program_module.g_table_route ;

13998: l_egl_table_route_id := null ;
13999: --
14000: open ben_plan_design_program_module.g_table_route('EGL');
14001: fetch ben_plan_design_program_module.g_table_route into l_egl_table_route_id ;
14002: close ben_plan_design_program_module.g_table_route ;
14003: --
14004: l_egl_result_type_cd := 'NO DISPLAY';
14005: --
14006: l_egl_copy_entity_result_id := null;

Line 14108: ben_plan_design_program_module.create_formula_result

14104: --
14105: if l_egl_rec.access_calc_rule is not null
14106: then
14107: --
14108: ben_plan_design_program_module.create_formula_result
14109: (
14110: p_validate => 0,
14111: p_copy_entity_result_id => l_egl_copy_entity_result_id,
14112: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 14127: ben_plan_design_program_module.create_formula_result

14123:
14124: if l_egl_rec.access_calc_rule2 is not null
14125: then
14126: --
14127: ben_plan_design_program_module.create_formula_result
14128: (
14129: p_validate => 0,
14130: p_copy_entity_result_id => l_egl_copy_entity_result_id,
14131: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 14146: ben_plan_design_program_module.create_formula_result

14142:
14143: if l_egl_rec.time_access_calc_rule1 is not null
14144: then
14145: --
14146: ben_plan_design_program_module.create_formula_result
14147: (
14148: p_validate => 0,
14149: p_copy_entity_result_id => l_egl_copy_entity_result_id,
14150: p_copy_entity_txn_id => p_copy_entity_txn_id,

Line 14166: ben_plan_design_program_module.create_formula_result

14162:
14163: if l_egl_rec.time_access_calc_rule2 is not null
14164: then
14165: --
14166: ben_plan_design_program_module.create_formula_result
14167: (
14168: p_validate => 0,
14169: p_copy_entity_result_id => l_egl_copy_entity_result_id,
14170: p_copy_entity_txn_id => p_copy_entity_txn_id,