[Home] [Help]
679: l_abr_acty_base_rt_esd := null;
680: for l_abr_rec in c_abr(l_parent_acty_base_rt_id,l_mirror_src_entity_result_id,'ABR' ) loop
681: --
682: l_table_route_id := null ;
683: open ben_plan_design_program_module.g_table_route('ABR');
684: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
685: close ben_plan_design_program_module.g_table_route ;
686: --
687: l_information5 := l_abr_rec.name; --'Intersection';
680: for l_abr_rec in c_abr(l_parent_acty_base_rt_id,l_mirror_src_entity_result_id,'ABR' ) loop
681: --
682: l_table_route_id := null ;
683: open ben_plan_design_program_module.g_table_route('ABR');
684: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
685: close ben_plan_design_program_module.g_table_route ;
686: --
687: l_information5 := l_abr_rec.name; --'Intersection';
688: --
681: --
682: l_table_route_id := null ;
683: open ben_plan_design_program_module.g_table_route('ABR');
684: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
685: close ben_plan_design_program_module.g_table_route ;
686: --
687: l_information5 := l_abr_rec.name; --'Intersection';
688: --
689: if p_effective_date between l_abr_rec.effective_start_date
963: --
964: if l_abr_rec.RATE_PERIODIZATION_RL is not null
965: then
966: --
967: ben_plan_design_program_module.create_formula_result
968: (
969: p_validate => 0
970: ,p_copy_entity_result_id => l_copy_entity_result_id
971: ,p_copy_entity_txn_id => p_copy_entity_txn_id
986: --
987: if l_abr_rec.MN_MX_ELCN_RL is not null
988: then
989: --
990: ben_plan_design_program_module.create_formula_result
991: (
992: p_validate => 0
993: ,p_copy_entity_result_id => l_copy_entity_result_id
994: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1005: -- Copy Lower Limit Calculation Rules if any (LWR_LMT_CALC_rl
1006: ---------------------------------------------------------------
1007: if l_abr_rec.lwr_lmt_calc_rl is not null then
1008: --
1009: ben_plan_design_program_module.create_formula_result
1010: (
1011: p_validate => 0
1012: ,p_copy_entity_result_id => l_copy_entity_result_id
1013: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1026: ---------------------------------------------------------------
1027:
1028: if l_abr_rec.prort_mn_ann_elcn_val_rl is not null then
1029: --
1030: ben_plan_design_program_module.create_formula_result
1031: (
1032: p_validate => 0
1033: ,p_copy_entity_result_id => l_copy_entity_result_id
1034: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1048: ---------------------------------------------------------------
1049:
1050: if l_abr_rec.prort_mx_ann_elcn_val_rl is not null then
1051: --
1052: ben_plan_design_program_module.create_formula_result
1053: (
1054: p_validate => 0
1055: ,p_copy_entity_result_id => l_copy_entity_result_id
1056: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1071:
1072:
1073: if l_abr_rec.prtl_mo_det_mthd_rl is not null then
1074: --
1075: ben_plan_design_program_module.create_formula_result
1076: (
1077: p_validate => 0
1078: ,p_copy_entity_result_id => l_copy_entity_result_id
1079: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1093: ---------------------------------------------------------------
1094:
1095: if l_abr_rec.prtl_mo_eff_dt_det_rl is not null then
1096: --
1097: ben_plan_design_program_module.create_formula_result
1098: (
1099: p_validate => 0
1100: ,p_copy_entity_result_id => l_copy_entity_result_id
1101: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1114: ---------------------------------------------------------------
1115:
1116: if l_abr_rec.rndg_rl is not null then
1117: --
1118: ben_plan_design_program_module.create_formula_result
1119: (
1120: p_validate => 0
1121: ,p_copy_entity_result_id => l_copy_entity_result_id
1122: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1135: ---------------------------------------------------------------
1136:
1137: if l_abr_rec.upr_lmt_calc_rl is not null then
1138: --
1139: ben_plan_design_program_module.create_formula_result
1140: (
1141: p_validate => 0
1142: ,p_copy_entity_result_id => l_copy_entity_result_id
1143: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1156: ---------------------------------------------------------------
1157:
1158: if l_abr_rec.val_calc_rl is not null then
1159: --
1160: ben_plan_design_program_module.create_formula_result
1161: (
1162: p_validate => 0
1163: ,p_copy_entity_result_id => l_copy_entity_result_id
1164: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1177: ---------------------------------------------------------------
1178:
1179: if l_abr_rec.input_va_calc_rl is not null then
1180: --
1181: ben_plan_design_program_module.create_formula_result
1182: (
1183: p_validate => 0
1184: ,p_copy_entity_result_id => l_copy_entity_result_id
1185: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1201: --
1202: if l_abr_rec.ELEMENT_DET_RL is not null
1203: then
1204: --
1205: ben_plan_design_program_module.create_formula_result
1206: (
1207: p_validate => 0
1208: ,p_copy_entity_result_id => l_copy_entity_result_id
1209: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1318: --
1319: for l_apf_rec in c_apf(l_parent_rec.acty_rt_pymt_sched_id,l_mirror_src_entity_result_id,'APF') loop
1320: --
1321: l_table_route_id := null ;
1322: open ben_plan_design_program_module.g_table_route('APF');
1323: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1324: close ben_plan_design_program_module.g_table_route ;
1325: --
1326: l_information5 := hr_general.decode_lookup('BEN_PYMT_SCHED',l_apf_rec.pymt_sched_cd); --'Intersection';
1319: for l_apf_rec in c_apf(l_parent_rec.acty_rt_pymt_sched_id,l_mirror_src_entity_result_id,'APF') loop
1320: --
1321: l_table_route_id := null ;
1322: open ben_plan_design_program_module.g_table_route('APF');
1323: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1324: close ben_plan_design_program_module.g_table_route ;
1325: --
1326: l_information5 := hr_general.decode_lookup('BEN_PYMT_SCHED',l_apf_rec.pymt_sched_cd); --'Intersection';
1327: --
1320: --
1321: l_table_route_id := null ;
1322: open ben_plan_design_program_module.g_table_route('APF');
1323: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1324: close ben_plan_design_program_module.g_table_route ;
1325: --
1326: l_information5 := hr_general.decode_lookup('BEN_PYMT_SCHED',l_apf_rec.pymt_sched_cd); --'Intersection';
1327: --
1328: if p_effective_date between l_apf_rec.effective_start_date
1403: ---------------------------------------------------------------
1404: --
1405: if l_apf_rec.pymt_sched_rl is not null then
1406: --
1407: ben_plan_design_program_module.create_formula_result
1408: (
1409: p_validate => 0
1410: ,p_copy_entity_result_id => l_copy_entity_result_id
1411: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1437: --
1438: for l_psq_rec in c_psq(l_parent_rec.pymt_sched_py_freq_id,l_mirror_src_entity_result_id,'PSQ') loop
1439: --
1440: l_table_route_id := null ;
1441: open ben_plan_design_program_module.g_table_route('PSQ');
1442: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1443: close ben_plan_design_program_module.g_table_route ;
1444: --
1445: l_information5 := hr_general.decode_lookup('BEN_FREQ',l_psq_rec.py_freq_cd); --'Intersection';
1438: for l_psq_rec in c_psq(l_parent_rec.pymt_sched_py_freq_id,l_mirror_src_entity_result_id,'PSQ') loop
1439: --
1440: l_table_route_id := null ;
1441: open ben_plan_design_program_module.g_table_route('PSQ');
1442: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1443: close ben_plan_design_program_module.g_table_route ;
1444: --
1445: l_information5 := hr_general.decode_lookup('BEN_FREQ',l_psq_rec.py_freq_cd); --'Intersection';
1446: --
1439: --
1440: l_table_route_id := null ;
1441: open ben_plan_design_program_module.g_table_route('PSQ');
1442: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1443: close ben_plan_design_program_module.g_table_route ;
1444: --
1445: l_information5 := hr_general.decode_lookup('BEN_FREQ',l_psq_rec.py_freq_cd); --'Intersection';
1446: --
1447: l_result_type_cd := 'DISPLAY';
1537: --
1538: for l_apl_rec in c_apl(l_parent_rec.acty_rt_ptd_lmt_id,l_mirror_src_entity_result_id,'APL1') loop
1539: --
1540: l_table_route_id := null ;
1541: open ben_plan_design_program_module.g_table_route('APL1');
1542: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1543: close ben_plan_design_program_module.g_table_route ;
1544: --
1545: l_information5 := ben_plan_design_program_module.get_ptd_lmt_name(l_apl_rec.ptd_lmt_id,p_effective_date);
1538: for l_apl_rec in c_apl(l_parent_rec.acty_rt_ptd_lmt_id,l_mirror_src_entity_result_id,'APL1') loop
1539: --
1540: l_table_route_id := null ;
1541: open ben_plan_design_program_module.g_table_route('APL1');
1542: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1543: close ben_plan_design_program_module.g_table_route ;
1544: --
1545: l_information5 := ben_plan_design_program_module.get_ptd_lmt_name(l_apl_rec.ptd_lmt_id,p_effective_date);
1546: --'Intersection';
1539: --
1540: l_table_route_id := null ;
1541: open ben_plan_design_program_module.g_table_route('APL1');
1542: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1543: close ben_plan_design_program_module.g_table_route ;
1544: --
1545: l_information5 := ben_plan_design_program_module.get_ptd_lmt_name(l_apl_rec.ptd_lmt_id,p_effective_date);
1546: --'Intersection';
1547: --
1541: open ben_plan_design_program_module.g_table_route('APL1');
1542: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1543: close ben_plan_design_program_module.g_table_route ;
1544: --
1545: l_information5 := ben_plan_design_program_module.get_ptd_lmt_name(l_apl_rec.ptd_lmt_id,p_effective_date);
1546: --'Intersection';
1547: --
1548: if p_effective_date between l_apl_rec.effective_start_date
1549: and l_apl_rec.effective_end_date then
1630:
1631: --
1632: l_ptd_lmt_id := l_parent_rec.ptd_lmt_id ;
1633: --
1634: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
1635: open c_object_exists(l_ptd_lmt_id,'PDL');
1636: fetch c_object_exists into l_dummy;
1637: if c_object_exists%found then
1638: close c_object_exists;
1643:
1644: for l_pdl_rec in c_pdl(l_parent_rec.ptd_lmt_id,l_mirror_src_entity_result_id,'PDL') loop
1645: --
1646: l_table_route_id := null ;
1647: open ben_plan_design_program_module.g_table_route('PDL');
1648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1649: close ben_plan_design_program_module.g_table_route ;
1650: --
1651: l_information5 := l_pdl_rec.name; --'Intersection';
1644: for l_pdl_rec in c_pdl(l_parent_rec.ptd_lmt_id,l_mirror_src_entity_result_id,'PDL') loop
1645: --
1646: l_table_route_id := null ;
1647: open ben_plan_design_program_module.g_table_route('PDL');
1648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1649: close ben_plan_design_program_module.g_table_route ;
1650: --
1651: l_information5 := l_pdl_rec.name; --'Intersection';
1652: --
1645: --
1646: l_table_route_id := null ;
1647: open ben_plan_design_program_module.g_table_route('PDL');
1648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1649: close ben_plan_design_program_module.g_table_route ;
1650: --
1651: l_information5 := l_pdl_rec.name; --'Intersection';
1652: --
1653: if p_effective_date between l_pdl_rec.effective_start_date
1735: ---------------------------------------------------------------
1736:
1737: if l_pdl_rec.ptd_lmt_calc_rl is not null then
1738: --
1739: ben_plan_design_program_module.create_formula_result
1740: (
1741: p_validate => 0
1742: ,p_copy_entity_result_id => l_copy_entity_result_id
1743: ,p_copy_entity_txn_id => p_copy_entity_txn_id
1799: --
1800: for l_avr_rec in c_avr(l_parent_rec.acty_vrbl_rt_id,l_mirror_src_entity_result_id,'AVR') loop
1801: --
1802: l_table_route_id := null ;
1803: open ben_plan_design_program_module.g_table_route('AVR');
1804: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1805: close ben_plan_design_program_module.g_table_route ;
1806: --
1807: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_avr_rec.vrbl_rt_prfl_id,
1800: for l_avr_rec in c_avr(l_parent_rec.acty_vrbl_rt_id,l_mirror_src_entity_result_id,'AVR') loop
1801: --
1802: l_table_route_id := null ;
1803: open ben_plan_design_program_module.g_table_route('AVR');
1804: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1805: close ben_plan_design_program_module.g_table_route ;
1806: --
1807: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_avr_rec.vrbl_rt_prfl_id,
1808: p_effective_date); --'Intersection';
1801: --
1802: l_table_route_id := null ;
1803: open ben_plan_design_program_module.g_table_route('AVR');
1804: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1805: close ben_plan_design_program_module.g_table_route ;
1806: --
1807: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_avr_rec.vrbl_rt_prfl_id,
1808: p_effective_date); --'Intersection';
1809: --
1803: open ben_plan_design_program_module.g_table_route('AVR');
1804: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1805: close ben_plan_design_program_module.g_table_route ;
1806: --
1807: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_avr_rec.vrbl_rt_prfl_id,
1808: p_effective_date); --'Intersection';
1809: --
1810: if p_effective_date between l_avr_rec.effective_start_date
1811: and l_avr_rec.effective_end_date then
1915: --
1916: for l_mtr_rec in c_mtr(l_parent_rec.mtchg_rt_id,l_mirror_src_entity_result_id,'MTR') loop
1917: --
1918: l_table_route_id := null ;
1919: open ben_plan_design_program_module.g_table_route('MTR');
1920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1921: close ben_plan_design_program_module.g_table_route ;
1922: --
1923: l_information5 := l_mtr_rec.from_pct_val ||' - '|| l_mtr_rec.to_pct_val; --'Intersection';
1916: for l_mtr_rec in c_mtr(l_parent_rec.mtchg_rt_id,l_mirror_src_entity_result_id,'MTR') loop
1917: --
1918: l_table_route_id := null ;
1919: open ben_plan_design_program_module.g_table_route('MTR');
1920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1921: close ben_plan_design_program_module.g_table_route ;
1922: --
1923: l_information5 := l_mtr_rec.from_pct_val ||' - '|| l_mtr_rec.to_pct_val; --'Intersection';
1924: --
1917: --
1918: l_table_route_id := null ;
1919: open ben_plan_design_program_module.g_table_route('MTR');
1920: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
1921: close ben_plan_design_program_module.g_table_route ;
1922: --
1923: l_information5 := l_mtr_rec.from_pct_val ||' - '|| l_mtr_rec.to_pct_val; --'Intersection';
1924: --
1925: if p_effective_date between l_mtr_rec.effective_start_date
2014: ---------------------------------------------------------------
2015:
2016: if l_mtr_rec.mtchg_rt_calc_rl is not null then
2017: --
2018: ben_plan_design_program_module.create_formula_result
2019: (
2020: p_validate => 0
2021: ,p_copy_entity_result_id => l_copy_entity_result_id
2022: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2074: --
2075: for l_pmr_rec in c_pmr(l_parent_rec.prtl_mo_rt_prtn_val_id,l_mirror_src_entity_result_id,'PMRPV') loop
2076: --
2077: l_table_route_id := null ;
2078: open ben_plan_design_program_module.g_table_route('PMRPV');
2079: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2080: close ben_plan_design_program_module.g_table_route ;
2081: --
2082: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
2075: for l_pmr_rec in c_pmr(l_parent_rec.prtl_mo_rt_prtn_val_id,l_mirror_src_entity_result_id,'PMRPV') loop
2076: --
2077: l_table_route_id := null ;
2078: open ben_plan_design_program_module.g_table_route('PMRPV');
2079: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2080: close ben_plan_design_program_module.g_table_route ;
2081: --
2082: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
2083: if l_pmr_rec.pct_val is not null then
2076: --
2077: l_table_route_id := null ;
2078: open ben_plan_design_program_module.g_table_route('PMRPV');
2079: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2080: close ben_plan_design_program_module.g_table_route ;
2081: --
2082: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
2083: if l_pmr_rec.pct_val is not null then
2084: l_information5 := l_information5 ||' '||l_pmr_rec.pct_val||'%';
2178: ---------------------------------------------------------------
2179:
2180: if l_pmr_rec.prtl_mo_prortn_rl is not null then
2181: --
2182: ben_plan_design_program_module.create_formula_result
2183: (
2184: p_validate => 0
2185: ,p_copy_entity_result_id => l_copy_entity_result_id
2186: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2202: ---------------------------------------------------------------
2203:
2204: if l_pmr_rec.rndg_rl is not null then
2205: --
2206: ben_plan_design_program_module.create_formula_result
2207: (
2208: p_validate => 0
2209: ,p_copy_entity_result_id => l_copy_entity_result_id
2210: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2237: --
2238: for l_eiv_rec in c_eiv(l_parent_rec.extra_input_value_id,l_mirror_src_entity_result_id,'EIV') loop
2239: --
2240: l_table_route_id := null ;
2241: open ben_plan_design_program_module.g_table_route('EIV');
2242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2243: close ben_plan_design_program_module.g_table_route ;
2244: --
2245:
2238: for l_eiv_rec in c_eiv(l_parent_rec.extra_input_value_id,l_mirror_src_entity_result_id,'EIV') loop
2239: --
2240: l_table_route_id := null ;
2241: open ben_plan_design_program_module.g_table_route('EIV');
2242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2243: close ben_plan_design_program_module.g_table_route ;
2244: --
2245:
2246: open c_element_type_id(l_eiv_rec.acty_base_rt_id,
2239: --
2240: l_table_route_id := null ;
2241: open ben_plan_design_program_module.g_table_route('EIV');
2242: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2243: close ben_plan_design_program_module.g_table_route ;
2244: --
2245:
2246: open c_element_type_id(l_eiv_rec.acty_base_rt_id,
2247: p_copy_entity_txn_id,'ABR');
2348: --
2349: for l_abc_rec in c_abc(l_parent_rec.acty_base_rt_ctfn_id,l_mirror_src_entity_result_id,'ABC') loop
2350: --
2351: l_table_route_id := null ;
2352: open ben_plan_design_program_module.g_table_route('ABC');
2353: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2354: close ben_plan_design_program_module.g_table_route ;
2355: --
2356: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_abc_rec.enrt_ctfn_typ_cd);
2349: for l_abc_rec in c_abc(l_parent_rec.acty_base_rt_ctfn_id,l_mirror_src_entity_result_id,'ABC') loop
2350: --
2351: l_table_route_id := null ;
2352: open ben_plan_design_program_module.g_table_route('ABC');
2353: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2354: close ben_plan_design_program_module.g_table_route ;
2355: --
2356: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_abc_rec.enrt_ctfn_typ_cd);
2357: --'Intersection';
2350: --
2351: l_table_route_id := null ;
2352: open ben_plan_design_program_module.g_table_route('ABC');
2353: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2354: close ben_plan_design_program_module.g_table_route ;
2355: --
2356: l_information5 := hr_general.decode_lookup('BEN_ENRT_CTFN_TYP',l_abc_rec.enrt_ctfn_typ_cd);
2357: --'Intersection';
2358: --
2437: ---------------------------------------------------------------
2438:
2439: if l_abc_rec.ctfn_rqd_when_rl is not null then
2440: --
2441: ben_plan_design_program_module.create_formula_result
2442: (
2443: p_validate => 0
2444: ,p_copy_entity_result_id => l_copy_entity_result_id
2445: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2640: --
2641: for l_ccm_rec in c_ccm(l_parent_rec.cvg_amt_calc_mthd_id,l_mirror_src_entity_result_id,'CCM') loop
2642: --
2643: l_table_route_id := null ;
2644: open ben_plan_design_program_module.g_table_route('CCM');
2645: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2646: close ben_plan_design_program_module.g_table_route ;
2647: --
2648: l_information5 := l_ccm_rec.name; --'Intersection';
2641: for l_ccm_rec in c_ccm(l_parent_rec.cvg_amt_calc_mthd_id,l_mirror_src_entity_result_id,'CCM') loop
2642: --
2643: l_table_route_id := null ;
2644: open ben_plan_design_program_module.g_table_route('CCM');
2645: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2646: close ben_plan_design_program_module.g_table_route ;
2647: --
2648: l_information5 := l_ccm_rec.name; --'Intersection';
2649: --
2642: --
2643: l_table_route_id := null ;
2644: open ben_plan_design_program_module.g_table_route('CCM');
2645: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2646: close ben_plan_design_program_module.g_table_route ;
2647: --
2648: l_information5 := l_ccm_rec.name; --'Intersection';
2649: --
2650: if p_effective_date between l_ccm_rec.effective_start_date
2751: ---------------------------------------------------------------
2752:
2753: if l_ccm_rec.lwr_lmt_calc_rl is not null then
2754: --
2755: ben_plan_design_program_module.create_formula_result
2756: (
2757: p_validate => 0
2758: ,p_copy_entity_result_id => l_copy_entity_result_id
2759: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2772: ---------------------------------------------------------------
2773:
2774: if l_ccm_rec.rndg_rl is not null then
2775: --
2776: ben_plan_design_program_module.create_formula_result
2777: (
2778: p_validate => 0
2779: ,p_copy_entity_result_id => l_copy_entity_result_id
2780: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2793: ---------------------------------------------------------------
2794:
2795: if l_ccm_rec.upr_lmt_calc_rl is not null then
2796: --
2797: ben_plan_design_program_module.create_formula_result
2798: (
2799: p_validate => 0
2800: ,p_copy_entity_result_id => l_copy_entity_result_id
2801: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2814: ---------------------------------------------------------------
2815:
2816: if l_ccm_rec.val_calc_rl is not null then
2817: --
2818: ben_plan_design_program_module.create_formula_result
2819: (
2820: p_validate => 0
2821: ,p_copy_entity_result_id => l_copy_entity_result_id
2822: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2870: --
2871: for l_brr_rec in c_brr(l_parent_rec.bnft_vrbl_rt_rl_id,l_mirror_src_entity_result_id,'BRR') loop
2872: --
2873: l_table_route_id := null ;
2874: open ben_plan_design_program_module.g_table_route('BRR');
2875: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2876: close ben_plan_design_program_module.g_table_route ;
2877: --
2878: l_information5 := ben_plan_design_program_module.get_formula_name(l_brr_rec.formula_id,p_effective_date);
2871: for l_brr_rec in c_brr(l_parent_rec.bnft_vrbl_rt_rl_id,l_mirror_src_entity_result_id,'BRR') loop
2872: --
2873: l_table_route_id := null ;
2874: open ben_plan_design_program_module.g_table_route('BRR');
2875: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2876: close ben_plan_design_program_module.g_table_route ;
2877: --
2878: l_information5 := ben_plan_design_program_module.get_formula_name(l_brr_rec.formula_id,p_effective_date);
2879: --'Intersection';
2872: --
2873: l_table_route_id := null ;
2874: open ben_plan_design_program_module.g_table_route('BRR');
2875: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2876: close ben_plan_design_program_module.g_table_route ;
2877: --
2878: l_information5 := ben_plan_design_program_module.get_formula_name(l_brr_rec.formula_id,p_effective_date);
2879: --'Intersection';
2880: --
2874: open ben_plan_design_program_module.g_table_route('BRR');
2875: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2876: close ben_plan_design_program_module.g_table_route ;
2877: --
2878: l_information5 := ben_plan_design_program_module.get_formula_name(l_brr_rec.formula_id,p_effective_date);
2879: --'Intersection';
2880: --
2881: if p_effective_date between l_brr_rec.effective_start_date
2882: and l_brr_rec.effective_end_date then
2957: ---------------------------------------------------------------
2958:
2959: if l_brr_rec.formula_id is not null then
2960: --
2961: ben_plan_design_program_module.create_formula_result
2962: (
2963: p_validate => 0
2964: ,p_copy_entity_result_id => l_copy_entity_result_id
2965: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2991: --
2992: for l_bvr_rec in c_bvr(l_parent_rec.bnft_vrbl_rt_id,l_mirror_src_entity_result_id,'BVR1') loop
2993: --
2994: l_table_route_id := null ;
2995: open ben_plan_design_program_module.g_table_route('BVR1');
2996: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2997: close ben_plan_design_program_module.g_table_route ;
2998: --
2999: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_bvr_rec.vrbl_rt_prfl_id
2992: for l_bvr_rec in c_bvr(l_parent_rec.bnft_vrbl_rt_id,l_mirror_src_entity_result_id,'BVR1') loop
2993: --
2994: l_table_route_id := null ;
2995: open ben_plan_design_program_module.g_table_route('BVR1');
2996: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2997: close ben_plan_design_program_module.g_table_route ;
2998: --
2999: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_bvr_rec.vrbl_rt_prfl_id
3000: ,p_effective_date); --'Intersection';
2993: --
2994: l_table_route_id := null ;
2995: open ben_plan_design_program_module.g_table_route('BVR1');
2996: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2997: close ben_plan_design_program_module.g_table_route ;
2998: --
2999: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_bvr_rec.vrbl_rt_prfl_id
3000: ,p_effective_date); --'Intersection';
3001: --
2995: open ben_plan_design_program_module.g_table_route('BVR1');
2996: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
2997: close ben_plan_design_program_module.g_table_route ;
2998: --
2999: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_bvr_rec.vrbl_rt_prfl_id
3000: ,p_effective_date); --'Intersection';
3001: --
3002: if p_effective_date between l_bvr_rec.effective_start_date
3003: and l_bvr_rec.effective_end_date then
3309: --
3310: for l_apr_rec in c_apr(l_parent_rec.actl_prem_id,l_mirror_src_entity_result_id,'APR') loop
3311: --
3312: l_table_route_id := null ;
3313: open ben_plan_design_program_module.g_table_route('APR');
3314: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3315: close ben_plan_design_program_module.g_table_route ;
3316: --
3317: l_information5 := l_apr_rec.name; --'Intersection';
3310: for l_apr_rec in c_apr(l_parent_rec.actl_prem_id,l_mirror_src_entity_result_id,'APR') loop
3311: --
3312: l_table_route_id := null ;
3313: open ben_plan_design_program_module.g_table_route('APR');
3314: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3315: close ben_plan_design_program_module.g_table_route ;
3316: --
3317: l_information5 := l_apr_rec.name; --'Intersection';
3318: --
3311: --
3312: l_table_route_id := null ;
3313: open ben_plan_design_program_module.g_table_route('APR');
3314: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3315: close ben_plan_design_program_module.g_table_route ;
3316: --
3317: l_information5 := l_apr_rec.name; --'Intersection';
3318: --
3319: if p_effective_date between l_apr_rec.effective_start_date
3424: ---------------------------------------------------------------
3425: --
3426: if l_apr_rec.lwr_lmt_calc_rl is not null then
3427: --
3428: ben_plan_design_program_module.create_formula_result
3429: (
3430: p_validate => 0
3431: ,p_copy_entity_result_id => l_copy_entity_result_id
3432: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3446: ---------------------------------------------------------------
3447: --
3448: if l_apr_rec.prtl_mo_det_mthd_rl is not null then
3449: --
3450: ben_plan_design_program_module.create_formula_result
3451: (
3452: p_validate => 0
3453: ,p_copy_entity_result_id => l_copy_entity_result_id
3454: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3467: ---------------------------------------------------------------
3468: --
3469: if l_apr_rec.rndg_rl is not null then
3470: --
3471: ben_plan_design_program_module.create_formula_result
3472: (
3473: p_validate => 0
3474: ,p_copy_entity_result_id => l_copy_entity_result_id
3475: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3488: ---------------------------------------------------------------
3489: --
3490: if l_apr_rec.upr_lmt_calc_rl is not null then
3491: --
3492: ben_plan_design_program_module.create_formula_result
3493: (
3494: p_validate => 0
3495: ,p_copy_entity_result_id => l_copy_entity_result_id
3496: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3509: ---------------------------------------------------------------
3510: --
3511: if l_apr_rec.val_calc_rl is not null then
3512: --
3513: ben_plan_design_program_module.create_formula_result
3514: (
3515: p_validate => 0
3516: ,p_copy_entity_result_id => l_copy_entity_result_id
3517: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3530: ---------------------------------------------------------------
3531: --
3532: if l_apr_rec.vrbl_rt_add_on_calc_rl is not null then
3533: --
3534: ben_plan_design_program_module.create_formula_result
3535: (
3536: p_validate => 0
3537: ,p_copy_entity_result_id => l_copy_entity_result_id
3538: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3585: --
3586: for l_pmr_rec in c_pmr(l_parent_rec.prtl_mo_rt_prtn_val_id,l_mirror_src_entity_result_id,'PMRPV') loop
3587: --
3588: l_table_route_id := null ;
3589: open ben_plan_design_program_module.g_table_route('PMRPV');
3590: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3591: close ben_plan_design_program_module.g_table_route ;
3592: --
3593: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
3586: for l_pmr_rec in c_pmr(l_parent_rec.prtl_mo_rt_prtn_val_id,l_mirror_src_entity_result_id,'PMRPV') loop
3587: --
3588: l_table_route_id := null ;
3589: open ben_plan_design_program_module.g_table_route('PMRPV');
3590: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3591: close ben_plan_design_program_module.g_table_route ;
3592: --
3593: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
3594: if l_pmr_rec.pct_val is not null then
3587: --
3588: l_table_route_id := null ;
3589: open ben_plan_design_program_module.g_table_route('PMRPV');
3590: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3591: close ben_plan_design_program_module.g_table_route ;
3592: --
3593: l_information5 := l_pmr_rec.from_dy_mo_num ||' - '||l_pmr_rec.to_dy_mo_num ;
3594: if l_pmr_rec.pct_val is not null then
3595: l_information5 := l_information5 ||' '||l_pmr_rec.pct_val||'%';
3690: ---------------------------------------------------------------
3691:
3692: if l_pmr_rec.prtl_mo_prortn_rl is not null then
3693: --
3694: ben_plan_design_program_module.create_formula_result
3695: (
3696: p_validate => 0
3697: ,p_copy_entity_result_id => l_copy_entity_result_id
3698: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3714: ---------------------------------------------------------------
3715:
3716: if l_pmr_rec.rndg_rl is not null then
3717: --
3718: ben_plan_design_program_module.create_formula_result
3719: (
3720: p_validate => 0
3721: ,p_copy_entity_result_id => l_copy_entity_result_id
3722: ,p_copy_entity_txn_id => p_copy_entity_txn_id
3749: --
3750: for l_apv_rec in c_apv(l_parent_rec.actl_prem_vrbl_rt_id,l_mirror_src_entity_result_id,'APV') loop
3751: --
3752: l_table_route_id := null ;
3753: open ben_plan_design_program_module.g_table_route('APV');
3754: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3755: close ben_plan_design_program_module.g_table_route ;
3756: --
3757: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_apv_rec.vrbl_rt_prfl_id
3750: for l_apv_rec in c_apv(l_parent_rec.actl_prem_vrbl_rt_id,l_mirror_src_entity_result_id,'APV') loop
3751: --
3752: l_table_route_id := null ;
3753: open ben_plan_design_program_module.g_table_route('APV');
3754: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3755: close ben_plan_design_program_module.g_table_route ;
3756: --
3757: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_apv_rec.vrbl_rt_prfl_id
3758: ,p_effective_date); --'Intersection';
3751: --
3752: l_table_route_id := null ;
3753: open ben_plan_design_program_module.g_table_route('APV');
3754: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3755: close ben_plan_design_program_module.g_table_route ;
3756: --
3757: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_apv_rec.vrbl_rt_prfl_id
3758: ,p_effective_date); --'Intersection';
3759: --
3753: open ben_plan_design_program_module.g_table_route('APV');
3754: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3755: close ben_plan_design_program_module.g_table_route ;
3756: --
3757: l_information5 := ben_plan_design_program_module.get_vrbl_rt_prfl_name(l_apv_rec.vrbl_rt_prfl_id
3758: ,p_effective_date); --'Intersection';
3759: --
3760: if p_effective_date between l_apv_rec.effective_start_date
3761: and l_apv_rec.effective_end_date then
3869: --
3870: for l_ava_rec in c_ava(l_parent_rec.actl_prem_vrbl_rt_rl_id,l_mirror_src_entity_result_id,'AVA') loop
3871: --
3872: l_table_route_id := null ;
3873: open ben_plan_design_program_module.g_table_route('AVA');
3874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3875: close ben_plan_design_program_module.g_table_route ;
3876: --
3877: l_information5 := ben_plan_design_program_module.get_formula_name(l_ava_rec.formula_id,p_effective_date);
3870: for l_ava_rec in c_ava(l_parent_rec.actl_prem_vrbl_rt_rl_id,l_mirror_src_entity_result_id,'AVA') loop
3871: --
3872: l_table_route_id := null ;
3873: open ben_plan_design_program_module.g_table_route('AVA');
3874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3875: close ben_plan_design_program_module.g_table_route ;
3876: --
3877: l_information5 := ben_plan_design_program_module.get_formula_name(l_ava_rec.formula_id,p_effective_date);
3878: --'Intersection';
3871: --
3872: l_table_route_id := null ;
3873: open ben_plan_design_program_module.g_table_route('AVA');
3874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3875: close ben_plan_design_program_module.g_table_route ;
3876: --
3877: l_information5 := ben_plan_design_program_module.get_formula_name(l_ava_rec.formula_id,p_effective_date);
3878: --'Intersection';
3879: --
3873: open ben_plan_design_program_module.g_table_route('AVA');
3874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
3875: close ben_plan_design_program_module.g_table_route ;
3876: --
3877: l_information5 := ben_plan_design_program_module.get_formula_name(l_ava_rec.formula_id,p_effective_date);
3878: --'Intersection';
3879: --
3880: if p_effective_date between l_ava_rec.effective_start_date
3881: and l_ava_rec.effective_end_date then
3958: ---------------------------------------------------------------
3959:
3960: if l_ava_rec.formula_id is not null then
3961: --
3962: ben_plan_design_program_module.create_formula_result
3963: (
3964: p_validate => 0
3965: ,p_copy_entity_result_id => l_copy_entity_result_id
3966: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4284: begin
4285: hr_utility.set_location('Start create_drpar_results',100);
4286: l_number_of_copies := p_number_of_copies ;
4287:
4288: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4289: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
4290: end if;
4291:
4292: if p_age_fctr_id is not null then
4285: hr_utility.set_location('Start create_drpar_results',100);
4286: l_number_of_copies := p_number_of_copies ;
4287:
4288: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4289: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
4290: end if;
4291:
4292: if p_age_fctr_id is not null then
4293:
4290: end if;
4291:
4292: if p_age_fctr_id is not null then
4293:
4294: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4295: open c_object_exists(p_age_fctr_id,'AGF');
4296: fetch c_object_exists into l_dummy;
4297: if c_object_exists%found then
4298: close c_object_exists;
4310: --
4311: for l_agf_rec in c_agf(p_age_fctr_id,l_mirror_src_entity_result_id,'AGF') loop
4312: --
4313: l_table_route_id := null ;
4314: open ben_plan_design_program_module.g_table_route('AGF');
4315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4316: close ben_plan_design_program_module.g_table_route ;
4317: --
4318: l_information5 := l_agf_rec.name; --'Intersection';
4311: for l_agf_rec in c_agf(p_age_fctr_id,l_mirror_src_entity_result_id,'AGF') loop
4312: --
4313: l_table_route_id := null ;
4314: open ben_plan_design_program_module.g_table_route('AGF');
4315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4316: close ben_plan_design_program_module.g_table_route ;
4317: --
4318: l_information5 := l_agf_rec.name; --'Intersection';
4319: --
4312: --
4313: l_table_route_id := null ;
4314: open ben_plan_design_program_module.g_table_route('AGF');
4315: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4316: close ben_plan_design_program_module.g_table_route ;
4317: --
4318: l_information5 := l_agf_rec.name; --'Intersection';
4319: --
4320: l_result_type_cd := 'DISPLAY';
4399: ------------------------------------------------------------
4400: --
4401: if l_agf_rec.age_calc_rl is not null then
4402: --
4403: ben_plan_design_program_module.create_formula_result
4404: (
4405: p_validate => 0
4406: ,p_copy_entity_result_id => l_copy_entity_result_id
4407: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4420: ------------------------------------------------------------
4421: --
4422: if l_agf_rec.age_det_rl is not null then
4423: --
4424: ben_plan_design_program_module.create_formula_result
4425: (
4426: p_validate => 0
4427: ,p_copy_entity_result_id => l_copy_entity_result_id
4428: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4441: ------------------------------------------------------------
4442: --
4443: if l_agf_rec.rndg_rl is not null then
4444: --
4445: ben_plan_design_program_module.create_formula_result
4446: (
4447: p_validate => 0
4448: ,p_copy_entity_result_id => l_copy_entity_result_id
4449: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4464: ---------------------------------------------------------------
4465: end if;
4466: if p_cmbn_age_los_fctr_id is not null then
4467:
4468: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4469: open c_object_exists(p_cmbn_age_los_fctr_id,'CLA');
4470: fetch c_object_exists into l_dummy;
4471: if c_object_exists%found then
4472: close c_object_exists;
4483: --
4484: for l_cla_rec in c_cla(p_cmbn_age_los_fctr_id,l_mirror_src_entity_result_id,'CLA') loop
4485: --
4486: l_table_route_id := null ;
4487: open ben_plan_design_program_module.g_table_route('CLA');
4488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4489: close ben_plan_design_program_module.g_table_route ;
4490: --
4491: l_information5 := l_cla_rec.name; --'Intersection';
4484: for l_cla_rec in c_cla(p_cmbn_age_los_fctr_id,l_mirror_src_entity_result_id,'CLA') loop
4485: --
4486: l_table_route_id := null ;
4487: open ben_plan_design_program_module.g_table_route('CLA');
4488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4489: close ben_plan_design_program_module.g_table_route ;
4490: --
4491: l_information5 := l_cla_rec.name; --'Intersection';
4492: --
4485: --
4486: l_table_route_id := null ;
4487: open ben_plan_design_program_module.g_table_route('CLA');
4488: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4489: close ben_plan_design_program_module.g_table_route ;
4490: --
4491: l_information5 := l_cla_rec.name; --'Intersection';
4492: --
4493: l_result_type_cd := 'DISPLAY';
4610: ---------------------------------------------------------------
4611: end if;
4612: if p_comp_lvl_fctr_id is not null then
4613:
4614: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4615: open c_object_exists(p_comp_lvl_fctr_id,'CLF');
4616: fetch c_object_exists into l_dummy;
4617: if c_object_exists%found then
4618: close c_object_exists;
4630: --
4631: for l_clf_rec in c_clf(p_comp_lvl_fctr_id,l_mirror_src_entity_result_id,'CLF') loop
4632: --
4633: l_table_route_id := null ;
4634: open ben_plan_design_program_module.g_table_route('CLF');
4635: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4636: close ben_plan_design_program_module.g_table_route ;
4637: --
4638: l_information5 := l_clf_rec.name; --'Intersection';
4631: for l_clf_rec in c_clf(p_comp_lvl_fctr_id,l_mirror_src_entity_result_id,'CLF') loop
4632: --
4633: l_table_route_id := null ;
4634: open ben_plan_design_program_module.g_table_route('CLF');
4635: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4636: close ben_plan_design_program_module.g_table_route ;
4637: --
4638: l_information5 := l_clf_rec.name; --'Intersection';
4639: --
4632: --
4633: l_table_route_id := null ;
4634: open ben_plan_design_program_module.g_table_route('CLF');
4635: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4636: close ben_plan_design_program_module.g_table_route ;
4637: --
4638: l_information5 := l_clf_rec.name; --'Intersection';
4639: --
4640: l_result_type_cd := 'DISPLAY';
4776: -------------------------------------------------------
4777: --
4778: if l_clf_rec.comp_calc_rl is not null then
4779: --
4780: ben_plan_design_program_module.create_formula_result
4781: (
4782: p_validate => 0
4783: ,p_copy_entity_result_id => l_copy_entity_result_id
4784: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4797: -------------------------------------------------------
4798: --
4799: if l_clf_rec.comp_lvl_det_rl is not null then
4800: --
4801: ben_plan_design_program_module.create_formula_result
4802: (
4803: p_validate => 0
4804: ,p_copy_entity_result_id => l_copy_entity_result_id
4805: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4818: -------------------------------------------------------
4819: --
4820: if l_clf_rec.rndg_rl is not null then
4821: --
4822: ben_plan_design_program_module.create_formula_result
4823: (
4824: p_validate => 0
4825: ,p_copy_entity_result_id => l_copy_entity_result_id
4826: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4855: end if;
4856: --
4857: if p_hrs_wkd_in_perd_fctr_id is not null then
4858:
4859: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
4860: open c_object_exists(p_hrs_wkd_in_perd_fctr_id,'HWF');
4861: fetch c_object_exists into l_dummy;
4862: if c_object_exists%found then
4863: close c_object_exists;
4876: for l_hwf_rec in c_hwf(p_hrs_wkd_in_perd_fctr_id,
4877: l_mirror_src_entity_result_id,'HWF') loop
4878: --
4879: l_table_route_id := null ;
4880: open ben_plan_design_program_module.g_table_route('HWF');
4881: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4882: close ben_plan_design_program_module.g_table_route ;
4883: --
4884: l_information5 := l_hwf_rec.name; --'Intersection';
4877: l_mirror_src_entity_result_id,'HWF') loop
4878: --
4879: l_table_route_id := null ;
4880: open ben_plan_design_program_module.g_table_route('HWF');
4881: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4882: close ben_plan_design_program_module.g_table_route ;
4883: --
4884: l_information5 := l_hwf_rec.name; --'Intersection';
4885: --
4878: --
4879: l_table_route_id := null ;
4880: open ben_plan_design_program_module.g_table_route('HWF');
4881: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
4882: close ben_plan_design_program_module.g_table_route ;
4883: --
4884: l_information5 := l_hwf_rec.name; --'Intersection';
4885: --
4886: l_result_type_cd := 'DISPLAY';
5017: ---------------------------------------------------------------
5018:
5019: if l_hwf_rec.hrs_wkd_calc_rl is not null then
5020: --
5021: ben_plan_design_program_module.create_formula_result
5022: (
5023: p_validate => 0
5024: ,p_copy_entity_result_id => l_copy_entity_result_id
5025: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5038: ---------------------------------------------------------------
5039:
5040: if l_hwf_rec.hrs_wkd_det_rl is not null then
5041: --
5042: ben_plan_design_program_module.create_formula_result
5043: (
5044: p_validate => 0
5045: ,p_copy_entity_result_id => l_copy_entity_result_id
5046: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5058: -- RNDG_RL -----------------
5059: ---------------------------------------------------------------
5060: if l_hwf_rec.rndg_rl is not null then
5061: --
5062: ben_plan_design_program_module.create_formula_result
5063: (
5064: p_validate => 0
5065: ,p_copy_entity_result_id => l_copy_entity_result_id
5066: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5095: end if;
5096: --
5097: if p_los_fctr_id is not null then
5098:
5099: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
5100: open c_object_exists(p_los_fctr_id,'LSF');
5101: fetch c_object_exists into l_dummy;
5102: if c_object_exists%found then
5103: close c_object_exists;
5114: --
5115: for l_lsf_rec in c_lsf(p_los_fctr_id,l_mirror_src_entity_result_id,'LSF') loop
5116: --
5117: l_table_route_id := null ;
5118: open ben_plan_design_program_module.g_table_route('LSF');
5119: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5120: close ben_plan_design_program_module.g_table_route ;
5121: --
5122: l_information5 := l_lsf_rec.name; --'Intersection';
5115: for l_lsf_rec in c_lsf(p_los_fctr_id,l_mirror_src_entity_result_id,'LSF') loop
5116: --
5117: l_table_route_id := null ;
5118: open ben_plan_design_program_module.g_table_route('LSF');
5119: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5120: close ben_plan_design_program_module.g_table_route ;
5121: --
5122: l_information5 := l_lsf_rec.name; --'Intersection';
5123: --
5116: --
5117: l_table_route_id := null ;
5118: open ben_plan_design_program_module.g_table_route('LSF');
5119: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5120: close ben_plan_design_program_module.g_table_route ;
5121: --
5122: l_information5 := l_lsf_rec.name; --'Intersection';
5123: --
5124: l_result_type_cd := 'DISPLAY';
5208: -- LOS_CALC_RL ------
5209: ---------------------------------------------------------------
5210: if l_lsf_rec.los_calc_rl is not null then
5211: --
5212: ben_plan_design_program_module.create_formula_result
5213: (
5214: p_validate => 0
5215: ,p_copy_entity_result_id => l_copy_entity_result_id
5216: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5228: -- LOS_DET_RL ------
5229: ---------------------------------------------------------------
5230: if l_lsf_rec.los_det_rl is not null then
5231: --
5232: ben_plan_design_program_module.create_formula_result
5233: (
5234: p_validate => 0
5235: ,p_copy_entity_result_id => l_copy_entity_result_id
5236: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5249: -- LOS_DT_TO_USE_RL ------
5250: ---------------------------------------------------------------
5251: if l_lsf_rec.los_dt_to_use_rl is not null then
5252: --
5253: ben_plan_design_program_module.create_formula_result
5254: (
5255: p_validate => 0
5256: ,p_copy_entity_result_id => l_copy_entity_result_id
5257: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5269: -- RNDG_RL ------
5270: ---------------------------------------------------------------
5271: if l_lsf_rec.rndg_rl is not null then
5272: --
5273: ben_plan_design_program_module.create_formula_result
5274: (
5275: p_validate => 0
5276: ,p_copy_entity_result_id => l_copy_entity_result_id
5277: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5292: ---------------------------------------------------------------
5293: end if;
5294: if p_pct_fl_tm_fctr_id is not null then
5295:
5296: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
5297: open c_object_exists(p_pct_fl_tm_fctr_id,'PFF');
5298: fetch c_object_exists into l_dummy;
5299: if c_object_exists%found then
5300: close c_object_exists;
5312: --
5313: for l_pff_rec in c_pff(p_pct_fl_tm_fctr_id,l_mirror_src_entity_result_id,'PFF') loop
5314: --
5315: l_table_route_id := null ;
5316: open ben_plan_design_program_module.g_table_route('PFF');
5317: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5318: close ben_plan_design_program_module.g_table_route ;
5319: --
5320: l_information5 := l_pff_rec.name; --'Intersection';
5313: for l_pff_rec in c_pff(p_pct_fl_tm_fctr_id,l_mirror_src_entity_result_id,'PFF') loop
5314: --
5315: l_table_route_id := null ;
5316: open ben_plan_design_program_module.g_table_route('PFF');
5317: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5318: close ben_plan_design_program_module.g_table_route ;
5319: --
5320: l_information5 := l_pff_rec.name; --'Intersection';
5321: --
5314: --
5315: l_table_route_id := null ;
5316: open ben_plan_design_program_module.g_table_route('PFF');
5317: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5318: close ben_plan_design_program_module.g_table_route ;
5319: --
5320: l_information5 := l_pff_rec.name; --'Intersection';
5321: --
5322: l_result_type_cd := 'DISPLAY';
5399: ---------------------------------------------------------------
5400:
5401: if l_pff_rec.rndg_rl is not null then
5402: --
5403: ben_plan_design_program_module.create_formula_result
5404: (
5405: p_validate => 0
5406: ,p_copy_entity_result_id => l_copy_entity_result_id
5407: ,p_copy_entity_txn_id => p_copy_entity_txn_id
5535: --
5536: for l_vep_rec in c_vep(l_parent_rec.vrbl_rt_elig_prfl_id,l_mirror_src_entity_result_id,'VEP') loop
5537: --
5538: l_table_route_id := null ;
5539: open ben_plan_design_program_module.g_table_route('VEP');
5540: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5541: close ben_plan_design_program_module.g_table_route ;
5542: --
5543: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_vep_rec.eligy_prfl_id
5536: for l_vep_rec in c_vep(l_parent_rec.vrbl_rt_elig_prfl_id,l_mirror_src_entity_result_id,'VEP') loop
5537: --
5538: l_table_route_id := null ;
5539: open ben_plan_design_program_module.g_table_route('VEP');
5540: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5541: close ben_plan_design_program_module.g_table_route ;
5542: --
5543: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_vep_rec.eligy_prfl_id
5544: ,p_effective_date); --'Intersection';
5537: --
5538: l_table_route_id := null ;
5539: open ben_plan_design_program_module.g_table_route('VEP');
5540: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5541: close ben_plan_design_program_module.g_table_route ;
5542: --
5543: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_vep_rec.eligy_prfl_id
5544: ,p_effective_date); --'Intersection';
5545: --
5539: open ben_plan_design_program_module.g_table_route('VEP');
5540: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
5541: close ben_plan_design_program_module.g_table_route ;
5542: --
5543: l_information5 := ben_plan_design_program_module.get_eligy_prfl_name(l_vep_rec.eligy_prfl_id
5544: ,p_effective_date); --'Intersection';
5545: --
5546: if p_effective_date between l_vep_rec.effective_start_date
5547: and l_vep_rec.effective_end_date then
5617: --
5618: end loop;
5619: --
5620:
5621: l_mirror_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_allow_dup_rslt;
5622:
5623: -- Create Eligibility Profiles and Criteria
5624:
5625: -- Bug 5059695
5625: -- Bug 5059695
5626: if(ben_plan_design_elpro_module.g_trasaction_category = 'PQHGSP') then
5627: l_dummy_g_pdw_allow_dup_rslt := null;
5628: else
5629: l_dummy_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
5630: end if;
5631: -- End Bug 5059695
5632:
5633: for l_parent_rec in c_elp_from_parent(l_vrbl_rt_elig_prfl_id) loop
5649: --Passed the value PDW_NO_DUP_RSLT to create_elig_prfl_results so that
5650: --no duplicate results are created
5651:
5652: end loop;
5653: ben_plan_design_program_module.g_pdw_allow_dup_rslt := l_mirror_g_pdw_allow_dup_rslt;
5654: -- ENH Avoid duplicates in Eligibility Profiles
5655: --reset the global allow dup results
5656:
5657: end loop;
7944:
7945: l_dummy varchar2(1);
7946: begin
7947:
7948: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7949: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
7950: end if;
7951:
7952: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7945: l_dummy varchar2(1);
7946: begin
7947:
7948: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7949: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
7950: end if;
7951:
7952: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7953: open c_object_exists(p_vrbl_rt_prfl_id,'VPF');
7948: if p_no_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7949: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
7950: end if;
7951:
7952: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
7953: open c_object_exists(p_vrbl_rt_prfl_id,'VPF');
7954: fetch c_object_exists into l_dummy;
7955: if c_object_exists%found then
7956: close c_object_exists;
7970: hr_utility.set_location('l_vrbl_rt_prfl_id'||l_vrbl_rt_prfl_id,100);
7971: for l_vpf_rec in c_vpf(l_vrbl_rt_prfl_id,l_mirror_src_entity_result_id,'VPF') loop
7972: --
7973: l_table_route_id := null ;
7974: open ben_plan_design_program_module.g_table_route('VPF');
7975: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7976: close ben_plan_design_program_module.g_table_route ;
7977: --
7978: l_information5 := l_vpf_rec.name; --'Intersection';
7971: for l_vpf_rec in c_vpf(l_vrbl_rt_prfl_id,l_mirror_src_entity_result_id,'VPF') loop
7972: --
7973: l_table_route_id := null ;
7974: open ben_plan_design_program_module.g_table_route('VPF');
7975: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7976: close ben_plan_design_program_module.g_table_route ;
7977: --
7978: l_information5 := l_vpf_rec.name; --'Intersection';
7979: --
7972: --
7973: l_table_route_id := null ;
7974: open ben_plan_design_program_module.g_table_route('VPF');
7975: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
7976: close ben_plan_design_program_module.g_table_route ;
7977: --
7978: l_information5 := l_vpf_rec.name; --'Intersection';
7979: --
7980: if p_effective_date between l_vpf_rec.effective_start_date
8150: ---------------------------------------------------------------
8151:
8152: if l_vpf_rec.lwr_lmt_calc_rl is not null then
8153: --
8154: ben_plan_design_program_module.create_formula_result
8155: (
8156: p_validate => 0
8157: ,p_copy_entity_result_id => l_copy_entity_result_id
8158: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8171: ---------------------------------------------------------------
8172:
8173: if l_vpf_rec.rndg_rl is not null then
8174: --
8175: ben_plan_design_program_module.create_formula_result
8176: (
8177: p_validate => 0
8178: ,p_copy_entity_result_id => l_copy_entity_result_id
8179: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8192: ---------------------------------------------------------------
8193:
8194: if l_vpf_rec.ultmt_lwr_lmt_calc_rl is not null then
8195: --
8196: ben_plan_design_program_module.create_formula_result
8197: (
8198: p_validate => 0
8199: ,p_copy_entity_result_id => l_copy_entity_result_id
8200: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8213: ---------------------------------------------------------------
8214:
8215: if l_vpf_rec.ultmt_upr_lmt_calc_rl is not null then
8216: --
8217: ben_plan_design_program_module.create_formula_result
8218: (
8219: p_validate => 0
8220: ,p_copy_entity_result_id => l_copy_entity_result_id
8221: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8234: ---------------------------------------------------------------
8235:
8236: if l_vpf_rec.upr_lmt_calc_rl is not null then
8237: --
8238: ben_plan_design_program_module.create_formula_result
8239: (
8240: p_validate => 0
8241: ,p_copy_entity_result_id => l_copy_entity_result_id
8242: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8256: ---------------------------------------------------------------
8257:
8258: if l_vpf_rec.val_calc_rl is not null then
8259: --
8260: ben_plan_design_program_module.create_formula_result
8261: (
8262: p_validate => 0
8263: ,p_copy_entity_result_id => l_copy_entity_result_id
8264: ,p_copy_entity_txn_id => p_copy_entity_txn_id
8327: --
8328: for l_art_rec in c_art(l_parent_rec.age_rt_id,l_mirror_src_entity_result_id,'ART') loop
8329: --
8330: l_table_route_id := null ;
8331: open ben_plan_design_program_module.g_table_route('ART');
8332: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8333: close ben_plan_design_program_module.g_table_route ;
8334: --
8335: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_art_rec.age_fctr_id)
8328: for l_art_rec in c_art(l_parent_rec.age_rt_id,l_mirror_src_entity_result_id,'ART') loop
8329: --
8330: l_table_route_id := null ;
8331: open ben_plan_design_program_module.g_table_route('ART');
8332: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8333: close ben_plan_design_program_module.g_table_route ;
8334: --
8335: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_art_rec.age_fctr_id)
8336: || ben_plan_design_program_module.get_exclude_message(l_art_rec.excld_flag);
8329: --
8330: l_table_route_id := null ;
8331: open ben_plan_design_program_module.g_table_route('ART');
8332: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8333: close ben_plan_design_program_module.g_table_route ;
8334: --
8335: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_art_rec.age_fctr_id)
8336: || ben_plan_design_program_module.get_exclude_message(l_art_rec.excld_flag);
8337: --'Intersection';
8331: open ben_plan_design_program_module.g_table_route('ART');
8332: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8333: close ben_plan_design_program_module.g_table_route ;
8334: --
8335: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_art_rec.age_fctr_id)
8336: || ben_plan_design_program_module.get_exclude_message(l_art_rec.excld_flag);
8337: --'Intersection';
8338: --
8339: if p_effective_date between l_art_rec.effective_start_date
8332: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8333: close ben_plan_design_program_module.g_table_route ;
8334: --
8335: l_information5 := ben_plan_design_program_module.get_age_fctr_name(l_art_rec.age_fctr_id)
8336: || ben_plan_design_program_module.get_exclude_message(l_art_rec.excld_flag);
8337: --'Intersection';
8338: --
8339: if p_effective_date between l_art_rec.effective_start_date
8340: and l_art_rec.effective_end_date then
8451: --
8452: for l_asr_rec in c_asr(l_parent_rec.asnt_set_rt_id,l_mirror_src_entity_result_id,'ASR') loop
8453: --
8454: l_table_route_id := null ;
8455: open ben_plan_design_program_module.g_table_route('ASR');
8456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8457: close ben_plan_design_program_module.g_table_route ;
8458: --
8459: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_asr_rec.assignment_set_id)
8452: for l_asr_rec in c_asr(l_parent_rec.asnt_set_rt_id,l_mirror_src_entity_result_id,'ASR') loop
8453: --
8454: l_table_route_id := null ;
8455: open ben_plan_design_program_module.g_table_route('ASR');
8456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8457: close ben_plan_design_program_module.g_table_route ;
8458: --
8459: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_asr_rec.assignment_set_id)
8460: || ben_plan_design_program_module.get_exclude_message(l_asr_rec.excld_flag);
8453: --
8454: l_table_route_id := null ;
8455: open ben_plan_design_program_module.g_table_route('ASR');
8456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8457: close ben_plan_design_program_module.g_table_route ;
8458: --
8459: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_asr_rec.assignment_set_id)
8460: || ben_plan_design_program_module.get_exclude_message(l_asr_rec.excld_flag);
8461: --'Intersection';
8455: open ben_plan_design_program_module.g_table_route('ASR');
8456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8457: close ben_plan_design_program_module.g_table_route ;
8458: --
8459: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_asr_rec.assignment_set_id)
8460: || ben_plan_design_program_module.get_exclude_message(l_asr_rec.excld_flag);
8461: --'Intersection';
8462: --
8463: if p_effective_date between l_asr_rec.effective_start_date
8456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8457: close ben_plan_design_program_module.g_table_route ;
8458: --
8459: l_information5 := ben_plan_design_program_module.get_assignment_set_name(l_asr_rec.assignment_set_id)
8460: || ben_plan_design_program_module.get_exclude_message(l_asr_rec.excld_flag);
8461: --'Intersection';
8462: --
8463: if p_effective_date between l_asr_rec.effective_start_date
8464: and l_asr_rec.effective_end_date then
8586: --
8587: for l_brg_rec in c_brg(l_parent_rec.benfts_grp_rt_id,l_mirror_src_entity_result_id,'BRG') loop
8588: --
8589: l_table_route_id := null ;
8590: open ben_plan_design_program_module.g_table_route('BRG');
8591: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8592: close ben_plan_design_program_module.g_table_route ;
8593: --
8594: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_brg_rec.benfts_grp_id)
8587: for l_brg_rec in c_brg(l_parent_rec.benfts_grp_rt_id,l_mirror_src_entity_result_id,'BRG') loop
8588: --
8589: l_table_route_id := null ;
8590: open ben_plan_design_program_module.g_table_route('BRG');
8591: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8592: close ben_plan_design_program_module.g_table_route ;
8593: --
8594: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_brg_rec.benfts_grp_id)
8595: || ben_plan_design_program_module.get_exclude_message(l_brg_rec.excld_flag);
8588: --
8589: l_table_route_id := null ;
8590: open ben_plan_design_program_module.g_table_route('BRG');
8591: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8592: close ben_plan_design_program_module.g_table_route ;
8593: --
8594: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_brg_rec.benfts_grp_id)
8595: || ben_plan_design_program_module.get_exclude_message(l_brg_rec.excld_flag);
8596: --'Intersection';
8590: open ben_plan_design_program_module.g_table_route('BRG');
8591: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8592: close ben_plan_design_program_module.g_table_route ;
8593: --
8594: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_brg_rec.benfts_grp_id)
8595: || ben_plan_design_program_module.get_exclude_message(l_brg_rec.excld_flag);
8596: --'Intersection';
8597: --
8598: if p_effective_date between l_brg_rec.effective_start_date
8591: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8592: close ben_plan_design_program_module.g_table_route ;
8593: --
8594: l_information5 := ben_plan_design_program_module.get_benfts_grp_name(l_brg_rec.benfts_grp_id)
8595: || ben_plan_design_program_module.get_exclude_message(l_brg_rec.excld_flag);
8596: --'Intersection';
8597: --
8598: if p_effective_date between l_brg_rec.effective_start_date
8599: and l_brg_rec.effective_end_date then
8703: --
8704: for l_bur_rec in c_bur(l_parent_rec.brgng_unit_rt_id,l_mirror_src_entity_result_id,'BUR') loop
8705: --
8706: l_table_route_id := null ;
8707: open ben_plan_design_program_module.g_table_route('BUR');
8708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8709: close ben_plan_design_program_module.g_table_route ;
8710: --
8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)
8704: for l_bur_rec in c_bur(l_parent_rec.brgng_unit_rt_id,l_mirror_src_entity_result_id,'BUR') loop
8705: --
8706: l_table_route_id := null ;
8707: open ben_plan_design_program_module.g_table_route('BUR');
8708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8709: close ben_plan_design_program_module.g_table_route ;
8710: --
8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)
8712: || ben_plan_design_program_module.get_exclude_message(l_bur_rec.excld_flag);
8705: --
8706: l_table_route_id := null ;
8707: open ben_plan_design_program_module.g_table_route('BUR');
8708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8709: close ben_plan_design_program_module.g_table_route ;
8710: --
8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)
8712: || ben_plan_design_program_module.get_exclude_message(l_bur_rec.excld_flag);
8713: --'Intersection';
8708: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8709: close ben_plan_design_program_module.g_table_route ;
8710: --
8711: l_information5 := hr_general.decode_lookup('BARGAINING_UNIT_CODE',l_bur_rec.brgng_unit_cd)
8712: || ben_plan_design_program_module.get_exclude_message(l_bur_rec.excld_flag);
8713: --'Intersection';
8714: --
8715: if p_effective_date between l_bur_rec.effective_start_date
8716: and l_bur_rec.effective_end_date then
8806: --
8807: for l_cmr_rec in c_cmr(l_parent_rec.cmbn_age_los_rt_id,l_mirror_src_entity_result_id,'CMR') loop
8808: --
8809: l_table_route_id := null ;
8810: open ben_plan_design_program_module.g_table_route('CMR');
8811: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8812: close ben_plan_design_program_module.g_table_route ;
8813: --
8814: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_cmr_rec.cmbn_age_los_fctr_id)
8807: for l_cmr_rec in c_cmr(l_parent_rec.cmbn_age_los_rt_id,l_mirror_src_entity_result_id,'CMR') loop
8808: --
8809: l_table_route_id := null ;
8810: open ben_plan_design_program_module.g_table_route('CMR');
8811: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8812: close ben_plan_design_program_module.g_table_route ;
8813: --
8814: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_cmr_rec.cmbn_age_los_fctr_id)
8815: || ben_plan_design_program_module.get_exclude_message(l_cmr_rec.excld_flag);
8808: --
8809: l_table_route_id := null ;
8810: open ben_plan_design_program_module.g_table_route('CMR');
8811: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8812: close ben_plan_design_program_module.g_table_route ;
8813: --
8814: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_cmr_rec.cmbn_age_los_fctr_id)
8815: || ben_plan_design_program_module.get_exclude_message(l_cmr_rec.excld_flag);
8816: --'Intersection';
8810: open ben_plan_design_program_module.g_table_route('CMR');
8811: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8812: close ben_plan_design_program_module.g_table_route ;
8813: --
8814: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_cmr_rec.cmbn_age_los_fctr_id)
8815: || ben_plan_design_program_module.get_exclude_message(l_cmr_rec.excld_flag);
8816: --'Intersection';
8817: --
8818: if p_effective_date between l_cmr_rec.effective_start_date
8811: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8812: close ben_plan_design_program_module.g_table_route ;
8813: --
8814: l_information5 := ben_plan_design_program_module.get_cmbn_age_los_fctr_name(l_cmr_rec.cmbn_age_los_fctr_id)
8815: || ben_plan_design_program_module.get_exclude_message(l_cmr_rec.excld_flag);
8816: --'Intersection';
8817: --
8818: if p_effective_date between l_cmr_rec.effective_start_date
8819: and l_cmr_rec.effective_end_date then
8928: hr_utility.set_location('l_comp_lvl_rt_id '||l_comp_lvl_rt_id,100);
8929: for l_clr_rec in c_clr(l_parent_rec.comp_lvl_rt_id,l_mirror_src_entity_result_id,'CLR') loop
8930: --
8931: l_table_route_id := null ;
8932: open ben_plan_design_program_module.g_table_route('CLR');
8933: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8934: close ben_plan_design_program_module.g_table_route ;
8935: --
8936: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_clr_rec.comp_lvl_fctr_id)
8929: for l_clr_rec in c_clr(l_parent_rec.comp_lvl_rt_id,l_mirror_src_entity_result_id,'CLR') loop
8930: --
8931: l_table_route_id := null ;
8932: open ben_plan_design_program_module.g_table_route('CLR');
8933: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8934: close ben_plan_design_program_module.g_table_route ;
8935: --
8936: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_clr_rec.comp_lvl_fctr_id)
8937: || ben_plan_design_program_module.get_exclude_message(l_clr_rec.excld_flag);
8930: --
8931: l_table_route_id := null ;
8932: open ben_plan_design_program_module.g_table_route('CLR');
8933: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8934: close ben_plan_design_program_module.g_table_route ;
8935: --
8936: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_clr_rec.comp_lvl_fctr_id)
8937: || ben_plan_design_program_module.get_exclude_message(l_clr_rec.excld_flag);
8938: --'Intersection';
8932: open ben_plan_design_program_module.g_table_route('CLR');
8933: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8934: close ben_plan_design_program_module.g_table_route ;
8935: --
8936: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_clr_rec.comp_lvl_fctr_id)
8937: || ben_plan_design_program_module.get_exclude_message(l_clr_rec.excld_flag);
8938: --'Intersection';
8939: --
8940: if p_effective_date between l_clr_rec.effective_start_date
8933: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
8934: close ben_plan_design_program_module.g_table_route ;
8935: --
8936: l_information5 := ben_plan_design_program_module.get_comp_lvl_fctr_name(l_clr_rec.comp_lvl_fctr_id)
8937: || ben_plan_design_program_module.get_exclude_message(l_clr_rec.excld_flag);
8938: --'Intersection';
8939: --
8940: if p_effective_date between l_clr_rec.effective_start_date
8941: and l_clr_rec.effective_end_date then
9050: --
9051: for l_dbr_rec in c_dbr(l_parent_rec.dsbld_rt_id,l_mirror_src_entity_result_id,'DBR') loop
9052: --
9053: l_table_route_id := null ;
9054: open ben_plan_design_program_module.g_table_route('DBR');
9055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9056: close ben_plan_design_program_module.g_table_route ;
9057: --
9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)
9051: for l_dbr_rec in c_dbr(l_parent_rec.dsbld_rt_id,l_mirror_src_entity_result_id,'DBR') loop
9052: --
9053: l_table_route_id := null ;
9054: open ben_plan_design_program_module.g_table_route('DBR');
9055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9056: close ben_plan_design_program_module.g_table_route ;
9057: --
9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)
9059: || ben_plan_design_program_module.get_exclude_message(l_dbr_rec.excld_flag);
9052: --
9053: l_table_route_id := null ;
9054: open ben_plan_design_program_module.g_table_route('DBR');
9055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9056: close ben_plan_design_program_module.g_table_route ;
9057: --
9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)
9059: || ben_plan_design_program_module.get_exclude_message(l_dbr_rec.excld_flag);
9060: --'Intersection';
9055: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9056: close ben_plan_design_program_module.g_table_route ;
9057: --
9058: l_information5 := hr_general.decode_lookup('REGISTERED_DISABLED',l_dbr_rec.dsbld_cd)
9059: || ben_plan_design_program_module.get_exclude_message(l_dbr_rec.excld_flag);
9060: --'Intersection';
9061: --
9062: if p_effective_date between l_dbr_rec.effective_start_date
9063: and l_dbr_rec.effective_end_date then
9154: for l_esr_rec in c_esr(l_parent_rec.ee_stat_rt_id,l_mirror_src_entity_result_id,'ESR') loop
9155: --
9156: hr_utility.set_location('l_parent_rec.ee_stat_rt_id '||l_parent_rec.ee_stat_rt_id,100);
9157: l_table_route_id := null ;
9158: open ben_plan_design_program_module.g_table_route('ESR');
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;
9161: --
9162: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_esr_rec.assignment_status_type_id)
9155: --
9156: hr_utility.set_location('l_parent_rec.ee_stat_rt_id '||l_parent_rec.ee_stat_rt_id,100);
9157: l_table_route_id := null ;
9158: open ben_plan_design_program_module.g_table_route('ESR');
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;
9161: --
9162: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_esr_rec.assignment_status_type_id)
9163: || ben_plan_design_program_module.get_exclude_message(l_esr_rec.excld_flag);
9156: hr_utility.set_location('l_parent_rec.ee_stat_rt_id '||l_parent_rec.ee_stat_rt_id,100);
9157: l_table_route_id := null ;
9158: open ben_plan_design_program_module.g_table_route('ESR');
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;
9161: --
9162: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_esr_rec.assignment_status_type_id)
9163: || ben_plan_design_program_module.get_exclude_message(l_esr_rec.excld_flag);
9164: --'Intersection';
9158: open ben_plan_design_program_module.g_table_route('ESR');
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;
9161: --
9162: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_esr_rec.assignment_status_type_id)
9163: || ben_plan_design_program_module.get_exclude_message(l_esr_rec.excld_flag);
9164: --'Intersection';
9165: --
9166: if p_effective_date between l_esr_rec.effective_start_date
9159: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9160: close ben_plan_design_program_module.g_table_route ;
9161: --
9162: l_information5 := ben_plan_design_program_module.get_assignment_sts_type_name(l_esr_rec.assignment_status_type_id)
9163: || ben_plan_design_program_module.get_exclude_message(l_esr_rec.excld_flag);
9164: --'Intersection';
9165: --
9166: if p_effective_date between l_esr_rec.effective_start_date
9167: and l_esr_rec.effective_end_date then
9292: --
9293: for l_ftr_rec in c_ftr(l_parent_rec.fl_tm_pt_tm_rt_id,l_mirror_src_entity_result_id,'FTR') loop
9294: --
9295: l_table_route_id := null ;
9296: open ben_plan_design_program_module.g_table_route('FTR');
9297: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9298: close ben_plan_design_program_module.g_table_route ;
9299: --
9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)
9293: for l_ftr_rec in c_ftr(l_parent_rec.fl_tm_pt_tm_rt_id,l_mirror_src_entity_result_id,'FTR') loop
9294: --
9295: l_table_route_id := null ;
9296: open ben_plan_design_program_module.g_table_route('FTR');
9297: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9298: close ben_plan_design_program_module.g_table_route ;
9299: --
9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)
9301: || ben_plan_design_program_module.get_exclude_message(l_ftr_rec.excld_flag); --'Intersection';
9294: --
9295: l_table_route_id := null ;
9296: open ben_plan_design_program_module.g_table_route('FTR');
9297: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9298: close ben_plan_design_program_module.g_table_route ;
9299: --
9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)
9301: || ben_plan_design_program_module.get_exclude_message(l_ftr_rec.excld_flag); --'Intersection';
9302: --
9297: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9298: close ben_plan_design_program_module.g_table_route ;
9299: --
9300: l_information5 := hr_general.decode_lookup('EMP_CAT',l_ftr_rec.fl_tm_pt_tm_cd)
9301: || ben_plan_design_program_module.get_exclude_message(l_ftr_rec.excld_flag); --'Intersection';
9302: --
9303: if p_effective_date between l_ftr_rec.effective_start_date
9304: and l_ftr_rec.effective_end_date then
9305: --
9394: --
9395: for l_gnr_rec in c_gnr(l_parent_rec.gndr_rt_id,l_mirror_src_entity_result_id,'GNR') loop
9396: --
9397: l_table_route_id := null ;
9398: open ben_plan_design_program_module.g_table_route('GNR');
9399: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9400: close ben_plan_design_program_module.g_table_route ;
9401: --
9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)
9395: for l_gnr_rec in c_gnr(l_parent_rec.gndr_rt_id,l_mirror_src_entity_result_id,'GNR') loop
9396: --
9397: l_table_route_id := null ;
9398: open ben_plan_design_program_module.g_table_route('GNR');
9399: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9400: close ben_plan_design_program_module.g_table_route ;
9401: --
9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)
9403: || ben_plan_design_program_module.get_exclude_message(l_gnr_rec.excld_flag); --'Intersection';
9396: --
9397: l_table_route_id := null ;
9398: open ben_plan_design_program_module.g_table_route('GNR');
9399: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9400: close ben_plan_design_program_module.g_table_route ;
9401: --
9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)
9403: || ben_plan_design_program_module.get_exclude_message(l_gnr_rec.excld_flag); --'Intersection';
9404: --
9399: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9400: close ben_plan_design_program_module.g_table_route ;
9401: --
9402: l_information5 := hr_general.decode_lookup('BEN_GNDR',l_gnr_rec.gndr_cd)
9403: || ben_plan_design_program_module.get_exclude_message(l_gnr_rec.excld_flag); --'Intersection';
9404: --
9405: if p_effective_date between l_gnr_rec.effective_start_date
9406: and l_gnr_rec.effective_end_date then
9407: --
9498: hr_utility.set_location('l_grade_rt_id '||l_grade_rt_id,100);
9499: for l_grr_rec in c_grr(l_parent_rec.grade_rt_id,l_mirror_src_entity_result_id,'GRR') loop
9500: --
9501: l_table_route_id := null ;
9502: open ben_plan_design_program_module.g_table_route('GRR');
9503: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9504: close ben_plan_design_program_module.g_table_route ;
9505: --
9506: l_information5 := ben_plan_design_program_module.get_grade_name(l_grr_rec.grade_id)
9499: for l_grr_rec in c_grr(l_parent_rec.grade_rt_id,l_mirror_src_entity_result_id,'GRR') loop
9500: --
9501: l_table_route_id := null ;
9502: open ben_plan_design_program_module.g_table_route('GRR');
9503: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9504: close ben_plan_design_program_module.g_table_route ;
9505: --
9506: l_information5 := ben_plan_design_program_module.get_grade_name(l_grr_rec.grade_id)
9507: || ben_plan_design_program_module.get_exclude_message(l_grr_rec.excld_flag); --'Intersection';
9500: --
9501: l_table_route_id := null ;
9502: open ben_plan_design_program_module.g_table_route('GRR');
9503: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9504: close ben_plan_design_program_module.g_table_route ;
9505: --
9506: l_information5 := ben_plan_design_program_module.get_grade_name(l_grr_rec.grade_id)
9507: || ben_plan_design_program_module.get_exclude_message(l_grr_rec.excld_flag); --'Intersection';
9508: --
9502: open ben_plan_design_program_module.g_table_route('GRR');
9503: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9504: close ben_plan_design_program_module.g_table_route ;
9505: --
9506: l_information5 := ben_plan_design_program_module.get_grade_name(l_grr_rec.grade_id)
9507: || ben_plan_design_program_module.get_exclude_message(l_grr_rec.excld_flag); --'Intersection';
9508: --
9509: if p_effective_date between l_grr_rec.effective_start_date
9510: and l_grr_rec.effective_end_date then
9503: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9504: close ben_plan_design_program_module.g_table_route ;
9505: --
9506: l_information5 := ben_plan_design_program_module.get_grade_name(l_grr_rec.grade_id)
9507: || ben_plan_design_program_module.get_exclude_message(l_grr_rec.excld_flag); --'Intersection';
9508: --
9509: if p_effective_date between l_grr_rec.effective_start_date
9510: and l_grr_rec.effective_end_date then
9511: --
9643: --
9644: for l_hsr_rec in c_hsr(l_parent_rec.hrly_slrd_rt_id,l_mirror_src_entity_result_id,'HSR') loop
9645: --
9646: l_table_route_id := null ;
9647: open ben_plan_design_program_module.g_table_route('HSR');
9648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9649: close ben_plan_design_program_module.g_table_route ;
9650: --
9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)
9644: for l_hsr_rec in c_hsr(l_parent_rec.hrly_slrd_rt_id,l_mirror_src_entity_result_id,'HSR') loop
9645: --
9646: l_table_route_id := null ;
9647: open ben_plan_design_program_module.g_table_route('HSR');
9648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9649: close ben_plan_design_program_module.g_table_route ;
9650: --
9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)
9652: || ben_plan_design_program_module.get_exclude_message(l_hsr_rec.excld_flag); --'Intersection';
9645: --
9646: l_table_route_id := null ;
9647: open ben_plan_design_program_module.g_table_route('HSR');
9648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9649: close ben_plan_design_program_module.g_table_route ;
9650: --
9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)
9652: || ben_plan_design_program_module.get_exclude_message(l_hsr_rec.excld_flag); --'Intersection';
9653: --
9648: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9649: close ben_plan_design_program_module.g_table_route ;
9650: --
9651: l_information5 := hr_general.decode_lookup('HOURLY_SALARIED_CODE',l_hsr_rec.hrly_slrd_cd)
9652: || ben_plan_design_program_module.get_exclude_message(l_hsr_rec.excld_flag); --'Intersection';
9653: --
9654: if p_effective_date between l_hsr_rec.effective_start_date
9655: and l_hsr_rec.effective_end_date then
9656: --
9746: hr_utility.set_location('l_hrs_wkd_in_perd_rt_id '||l_hrs_wkd_in_perd_rt_id,100);
9747: for l_hwr_rec in c_hwr(l_parent_rec.hrs_wkd_in_perd_rt_id,l_mirror_src_entity_result_id,'HWR') loop
9748: --
9749: l_table_route_id := null ;
9750: open ben_plan_design_program_module.g_table_route('HWR');
9751: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9752: close ben_plan_design_program_module.g_table_route ;
9753: --
9754: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_hwr_rec.hrs_wkd_in_perd_fctr_id)
9747: for l_hwr_rec in c_hwr(l_parent_rec.hrs_wkd_in_perd_rt_id,l_mirror_src_entity_result_id,'HWR') loop
9748: --
9749: l_table_route_id := null ;
9750: open ben_plan_design_program_module.g_table_route('HWR');
9751: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9752: close ben_plan_design_program_module.g_table_route ;
9753: --
9754: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_hwr_rec.hrs_wkd_in_perd_fctr_id)
9755: || ben_plan_design_program_module.get_exclude_message(l_hwr_rec.excld_flag);
9748: --
9749: l_table_route_id := null ;
9750: open ben_plan_design_program_module.g_table_route('HWR');
9751: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9752: close ben_plan_design_program_module.g_table_route ;
9753: --
9754: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_hwr_rec.hrs_wkd_in_perd_fctr_id)
9755: || ben_plan_design_program_module.get_exclude_message(l_hwr_rec.excld_flag);
9756: --'Intersection';
9750: open ben_plan_design_program_module.g_table_route('HWR');
9751: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9752: close ben_plan_design_program_module.g_table_route ;
9753: --
9754: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_hwr_rec.hrs_wkd_in_perd_fctr_id)
9755: || ben_plan_design_program_module.get_exclude_message(l_hwr_rec.excld_flag);
9756: --'Intersection';
9757: --
9758: if p_effective_date between l_hwr_rec.effective_start_date
9751: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9752: close ben_plan_design_program_module.g_table_route ;
9753: --
9754: l_information5 := ben_plan_design_program_module.get_hrs_wkd_in_perd_fctr_name(l_hwr_rec.hrs_wkd_in_perd_fctr_id)
9755: || ben_plan_design_program_module.get_exclude_message(l_hwr_rec.excld_flag);
9756: --'Intersection';
9757: --
9758: if p_effective_date between l_hwr_rec.effective_start_date
9759: and l_hwr_rec.effective_end_date then
9869: --
9870: for l_lmm_rec in c_lmm(l_parent_rec.lbr_mmbr_rt_id,l_mirror_src_entity_result_id,'LMM') loop
9871: --
9872: l_table_route_id := null ;
9873: open ben_plan_design_program_module.g_table_route('LMM');
9874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9875: close ben_plan_design_program_module.g_table_route ;
9876: --
9877: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_lmm_rec.lbr_mmbr_flag)
9870: for l_lmm_rec in c_lmm(l_parent_rec.lbr_mmbr_rt_id,l_mirror_src_entity_result_id,'LMM') loop
9871: --
9872: l_table_route_id := null ;
9873: open ben_plan_design_program_module.g_table_route('LMM');
9874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9875: close ben_plan_design_program_module.g_table_route ;
9876: --
9877: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_lmm_rec.lbr_mmbr_flag)
9878: || ben_plan_design_program_module.get_exclude_message(l_lmm_rec.excld_flag);
9871: --
9872: l_table_route_id := null ;
9873: open ben_plan_design_program_module.g_table_route('LMM');
9874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9875: close ben_plan_design_program_module.g_table_route ;
9876: --
9877: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_lmm_rec.lbr_mmbr_flag)
9878: || ben_plan_design_program_module.get_exclude_message(l_lmm_rec.excld_flag);
9879: --'Intersection';
9873: open ben_plan_design_program_module.g_table_route('LMM');
9874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9875: close ben_plan_design_program_module.g_table_route ;
9876: --
9877: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_lmm_rec.lbr_mmbr_flag)
9878: || ben_plan_design_program_module.get_exclude_message(l_lmm_rec.excld_flag);
9879: --'Intersection';
9880: --
9881: if p_effective_date between l_lmm_rec.effective_start_date
9874: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9875: close ben_plan_design_program_module.g_table_route ;
9876: --
9877: l_information5 := ben_plan_design_program_module.get_lbr_mmbr_name(l_lmm_rec.lbr_mmbr_flag)
9878: || ben_plan_design_program_module.get_exclude_message(l_lmm_rec.excld_flag);
9879: --'Intersection';
9880: --
9881: if p_effective_date between l_lmm_rec.effective_start_date
9882: and l_lmm_rec.effective_end_date then
9974: hr_utility.set_location('l_lgl_enty_rt_id '||l_lgl_enty_rt_id,100);
9975: for l_ler_rec in c_ler(l_parent_rec.lgl_enty_rt_id,l_mirror_src_entity_result_id,'LER1') loop
9976: --
9977: l_table_route_id := null ;
9978: open ben_plan_design_program_module.g_table_route('LER1');
9979: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9980: close ben_plan_design_program_module.g_table_route ;
9981: --
9982: l_information5 := ben_plan_design_program_module.get_organization_name(l_ler_rec.organization_id)
9975: for l_ler_rec in c_ler(l_parent_rec.lgl_enty_rt_id,l_mirror_src_entity_result_id,'LER1') loop
9976: --
9977: l_table_route_id := null ;
9978: open ben_plan_design_program_module.g_table_route('LER1');
9979: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9980: close ben_plan_design_program_module.g_table_route ;
9981: --
9982: l_information5 := ben_plan_design_program_module.get_organization_name(l_ler_rec.organization_id)
9983: || ben_plan_design_program_module.get_exclude_message(l_ler_rec.excld_flag);
9976: --
9977: l_table_route_id := null ;
9978: open ben_plan_design_program_module.g_table_route('LER1');
9979: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9980: close ben_plan_design_program_module.g_table_route ;
9981: --
9982: l_information5 := ben_plan_design_program_module.get_organization_name(l_ler_rec.organization_id)
9983: || ben_plan_design_program_module.get_exclude_message(l_ler_rec.excld_flag);
9984: --'Intersection';
9978: open ben_plan_design_program_module.g_table_route('LER1');
9979: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9980: close ben_plan_design_program_module.g_table_route ;
9981: --
9982: l_information5 := ben_plan_design_program_module.get_organization_name(l_ler_rec.organization_id)
9983: || ben_plan_design_program_module.get_exclude_message(l_ler_rec.excld_flag);
9984: --'Intersection';
9985: --
9986: if p_effective_date between l_ler_rec.effective_start_date
9979: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
9980: close ben_plan_design_program_module.g_table_route ;
9981: --
9982: l_information5 := ben_plan_design_program_module.get_organization_name(l_ler_rec.organization_id)
9983: || ben_plan_design_program_module.get_exclude_message(l_ler_rec.excld_flag);
9984: --'Intersection';
9985: --
9986: if p_effective_date between l_ler_rec.effective_start_date
9987: and l_ler_rec.effective_end_date then
10126: hr_utility.set_location('l_loa_rsn_rt_id '||l_loa_rsn_rt_id,100);
10127: for l_lar_rec in c_lar(l_parent_rec.loa_rsn_rt_id,l_mirror_src_entity_result_id,'LAR') loop
10128: --
10129: l_table_route_id := null ;
10130: open ben_plan_design_program_module.g_table_route('LAR');
10131: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10132: close ben_plan_design_program_module.g_table_route ;
10133: --
10134: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_lar_rec.absence_attendance_type_id)
10127: for l_lar_rec in c_lar(l_parent_rec.loa_rsn_rt_id,l_mirror_src_entity_result_id,'LAR') loop
10128: --
10129: l_table_route_id := null ;
10130: open ben_plan_design_program_module.g_table_route('LAR');
10131: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10132: close ben_plan_design_program_module.g_table_route ;
10133: --
10134: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_lar_rec.absence_attendance_type_id)
10135: || ben_plan_design_program_module.get_exclude_message(l_lar_rec.excld_flag);
10128: --
10129: l_table_route_id := null ;
10130: open ben_plan_design_program_module.g_table_route('LAR');
10131: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10132: close ben_plan_design_program_module.g_table_route ;
10133: --
10134: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_lar_rec.absence_attendance_type_id)
10135: || ben_plan_design_program_module.get_exclude_message(l_lar_rec.excld_flag);
10136: --'Intersection';
10130: open ben_plan_design_program_module.g_table_route('LAR');
10131: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10132: close ben_plan_design_program_module.g_table_route ;
10133: --
10134: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_lar_rec.absence_attendance_type_id)
10135: || ben_plan_design_program_module.get_exclude_message(l_lar_rec.excld_flag);
10136: --'Intersection';
10137: --
10138: if p_effective_date between l_lar_rec.effective_start_date
10131: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10132: close ben_plan_design_program_module.g_table_route ;
10133: --
10134: l_information5 := ben_plan_design_program_module.get_absence_type_name(l_lar_rec.absence_attendance_type_id)
10135: || ben_plan_design_program_module.get_exclude_message(l_lar_rec.excld_flag);
10136: --'Intersection';
10137: --
10138: if p_effective_date between l_lar_rec.effective_start_date
10139: and l_lar_rec.effective_end_date then
10296: --
10297: for l_lsr_rec in c_lsr(l_parent_rec.los_rt_id,l_mirror_src_entity_result_id,'LSR') loop
10298: --
10299: l_table_route_id := null ;
10300: open ben_plan_design_program_module.g_table_route('LSR');
10301: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10302: close ben_plan_design_program_module.g_table_route ;
10303: --
10304: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_lsr_rec.los_fctr_id)
10297: for l_lsr_rec in c_lsr(l_parent_rec.los_rt_id,l_mirror_src_entity_result_id,'LSR') loop
10298: --
10299: l_table_route_id := null ;
10300: open ben_plan_design_program_module.g_table_route('LSR');
10301: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10302: close ben_plan_design_program_module.g_table_route ;
10303: --
10304: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_lsr_rec.los_fctr_id)
10305: || ben_plan_design_program_module.get_exclude_message(l_lsr_rec.excld_flag);
10298: --
10299: l_table_route_id := null ;
10300: open ben_plan_design_program_module.g_table_route('LSR');
10301: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10302: close ben_plan_design_program_module.g_table_route ;
10303: --
10304: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_lsr_rec.los_fctr_id)
10305: || ben_plan_design_program_module.get_exclude_message(l_lsr_rec.excld_flag);
10306: --'Intersection';
10300: open ben_plan_design_program_module.g_table_route('LSR');
10301: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10302: close ben_plan_design_program_module.g_table_route ;
10303: --
10304: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_lsr_rec.los_fctr_id)
10305: || ben_plan_design_program_module.get_exclude_message(l_lsr_rec.excld_flag);
10306: --'Intersection';
10307: --
10308: if p_effective_date between l_lsr_rec.effective_start_date
10301: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10302: close ben_plan_design_program_module.g_table_route ;
10303: --
10304: l_information5 := ben_plan_design_program_module.get_los_fctr_name(l_lsr_rec.los_fctr_id)
10305: || ben_plan_design_program_module.get_exclude_message(l_lsr_rec.excld_flag);
10306: --'Intersection';
10307: --
10308: if p_effective_date between l_lsr_rec.effective_start_date
10309: and l_lsr_rec.effective_end_date then
10416: --
10417: for l_lrn_rec in c_lrn(l_parent_rec.lvg_rsn_rt_id,l_mirror_src_entity_result_id,'LRN') loop
10418: --
10419: l_table_route_id := null ;
10420: open ben_plan_design_program_module.g_table_route('LRN');
10421: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10422: close ben_plan_design_program_module.g_table_route ;
10423: --
10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)
10417: for l_lrn_rec in c_lrn(l_parent_rec.lvg_rsn_rt_id,l_mirror_src_entity_result_id,'LRN') loop
10418: --
10419: l_table_route_id := null ;
10420: open ben_plan_design_program_module.g_table_route('LRN');
10421: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10422: close ben_plan_design_program_module.g_table_route ;
10423: --
10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)
10425: || ben_plan_design_program_module.get_exclude_message(l_lrn_rec.excld_flag);
10418: --
10419: l_table_route_id := null ;
10420: open ben_plan_design_program_module.g_table_route('LRN');
10421: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10422: close ben_plan_design_program_module.g_table_route ;
10423: --
10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)
10425: || ben_plan_design_program_module.get_exclude_message(l_lrn_rec.excld_flag);
10426: --
10421: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10422: close ben_plan_design_program_module.g_table_route ;
10423: --
10424: l_information5 := hr_general.decode_lookup('LEAV_REAS',l_lrn_rec.lvg_rsn_cd)
10425: || ben_plan_design_program_module.get_exclude_message(l_lrn_rec.excld_flag);
10426: --
10427: if p_effective_date between l_lrn_rec.effective_start_date
10428: and l_lrn_rec.effective_end_date then
10429: --
10520: hr_utility.set_location('l_org_unit_rt_id '||l_org_unit_rt_id,100);
10521: for l_our_rec in c_our(l_parent_rec.org_unit_rt_id,l_mirror_src_entity_result_id,'OUR') loop
10522: --
10523: l_table_route_id := null ;
10524: open ben_plan_design_program_module.g_table_route('OUR');
10525: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10526: close ben_plan_design_program_module.g_table_route ;
10527: --
10528: l_information5 := ben_plan_design_program_module.get_organization_name(l_our_rec.organization_id)
10521: for l_our_rec in c_our(l_parent_rec.org_unit_rt_id,l_mirror_src_entity_result_id,'OUR') loop
10522: --
10523: l_table_route_id := null ;
10524: open ben_plan_design_program_module.g_table_route('OUR');
10525: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10526: close ben_plan_design_program_module.g_table_route ;
10527: --
10528: l_information5 := ben_plan_design_program_module.get_organization_name(l_our_rec.organization_id)
10529: || ben_plan_design_program_module.get_exclude_message(l_our_rec.excld_flag);
10522: --
10523: l_table_route_id := null ;
10524: open ben_plan_design_program_module.g_table_route('OUR');
10525: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10526: close ben_plan_design_program_module.g_table_route ;
10527: --
10528: l_information5 := ben_plan_design_program_module.get_organization_name(l_our_rec.organization_id)
10529: || ben_plan_design_program_module.get_exclude_message(l_our_rec.excld_flag);
10530: --'Intersection';
10524: open ben_plan_design_program_module.g_table_route('OUR');
10525: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10526: close ben_plan_design_program_module.g_table_route ;
10527: --
10528: l_information5 := ben_plan_design_program_module.get_organization_name(l_our_rec.organization_id)
10529: || ben_plan_design_program_module.get_exclude_message(l_our_rec.excld_flag);
10530: --'Intersection';
10531: --
10532: if p_effective_date between l_our_rec.effective_start_date
10525: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10526: close ben_plan_design_program_module.g_table_route ;
10527: --
10528: l_information5 := ben_plan_design_program_module.get_organization_name(l_our_rec.organization_id)
10529: || ben_plan_design_program_module.get_exclude_message(l_our_rec.excld_flag);
10530: --'Intersection';
10531: --
10532: if p_effective_date between l_our_rec.effective_start_date
10533: and l_our_rec.effective_end_date then
10667: --
10668: for l_pfr_rec in c_pfr(l_parent_rec.pct_fl_tm_rt_id,l_mirror_src_entity_result_id,'PFR') loop
10669: --
10670: l_table_route_id := null ;
10671: open ben_plan_design_program_module.g_table_route('PFR');
10672: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10673: close ben_plan_design_program_module.g_table_route ;
10674: --
10675: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_pfr_rec.pct_fl_tm_fctr_id)
10668: for l_pfr_rec in c_pfr(l_parent_rec.pct_fl_tm_rt_id,l_mirror_src_entity_result_id,'PFR') loop
10669: --
10670: l_table_route_id := null ;
10671: open ben_plan_design_program_module.g_table_route('PFR');
10672: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10673: close ben_plan_design_program_module.g_table_route ;
10674: --
10675: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_pfr_rec.pct_fl_tm_fctr_id)
10676: || ben_plan_design_program_module.get_exclude_message(l_pfr_rec.excld_flag);
10669: --
10670: l_table_route_id := null ;
10671: open ben_plan_design_program_module.g_table_route('PFR');
10672: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10673: close ben_plan_design_program_module.g_table_route ;
10674: --
10675: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_pfr_rec.pct_fl_tm_fctr_id)
10676: || ben_plan_design_program_module.get_exclude_message(l_pfr_rec.excld_flag);
10677: --'Intersection';
10671: open ben_plan_design_program_module.g_table_route('PFR');
10672: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10673: close ben_plan_design_program_module.g_table_route ;
10674: --
10675: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_pfr_rec.pct_fl_tm_fctr_id)
10676: || ben_plan_design_program_module.get_exclude_message(l_pfr_rec.excld_flag);
10677: --'Intersection';
10678: --
10679: if p_effective_date between l_pfr_rec.effective_start_date
10672: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10673: close ben_plan_design_program_module.g_table_route ;
10674: --
10675: l_information5 := ben_plan_design_program_module.get_pct_fl_tm_fctr_name(l_pfr_rec.pct_fl_tm_fctr_id)
10676: || ben_plan_design_program_module.get_exclude_message(l_pfr_rec.excld_flag);
10677: --'Intersection';
10678: --
10679: if p_effective_date between l_pfr_rec.effective_start_date
10680: and l_pfr_rec.effective_end_date then
10790: hr_utility.set_location('l_per_typ_rt_id '||l_per_typ_rt_id,100);
10791: for l_ptr_rec in c_ptr(l_parent_rec.per_typ_rt_id,l_mirror_src_entity_result_id,'PTR') loop
10792: --
10793: l_table_route_id := null ;
10794: open ben_plan_design_program_module.g_table_route('PTR');
10795: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10796: close ben_plan_design_program_module.g_table_route ;
10797: --
10798: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ptr_rec.person_type_id)
10791: for l_ptr_rec in c_ptr(l_parent_rec.per_typ_rt_id,l_mirror_src_entity_result_id,'PTR') loop
10792: --
10793: l_table_route_id := null ;
10794: open ben_plan_design_program_module.g_table_route('PTR');
10795: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10796: close ben_plan_design_program_module.g_table_route ;
10797: --
10798: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ptr_rec.person_type_id)
10799: || ben_plan_design_program_module.get_exclude_message(l_ptr_rec.excld_flag);
10792: --
10793: l_table_route_id := null ;
10794: open ben_plan_design_program_module.g_table_route('PTR');
10795: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10796: close ben_plan_design_program_module.g_table_route ;
10797: --
10798: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ptr_rec.person_type_id)
10799: || ben_plan_design_program_module.get_exclude_message(l_ptr_rec.excld_flag);
10800: --'Intersection';
10794: open ben_plan_design_program_module.g_table_route('PTR');
10795: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10796: close ben_plan_design_program_module.g_table_route ;
10797: --
10798: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ptr_rec.person_type_id)
10799: || ben_plan_design_program_module.get_exclude_message(l_ptr_rec.excld_flag);
10800: --'Intersection';
10801: --
10802: if p_effective_date between l_ptr_rec.effective_start_date
10795: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10796: close ben_plan_design_program_module.g_table_route ;
10797: --
10798: l_information5 := ben_plan_design_program_module.get_person_type_name(l_ptr_rec.person_type_id)
10799: || ben_plan_design_program_module.get_exclude_message(l_ptr_rec.excld_flag);
10800: --'Intersection';
10801: --
10802: if p_effective_date between l_ptr_rec.effective_start_date
10803: and l_ptr_rec.effective_end_date then
10927: --
10928: for l_prt_rec in c_prt(l_parent_rec.poe_rt_id,l_mirror_src_entity_result_id,'PRT') loop
10929: --
10930: l_table_route_id := null ;
10931: open ben_plan_design_program_module.g_table_route('PRT');
10932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10933: close ben_plan_design_program_module.g_table_route ;
10934: --
10935: l_information5 := l_prt_rec.mn_poe_num ||' - '|| l_prt_rec.mx_poe_num ||
10928: for l_prt_rec in c_prt(l_parent_rec.poe_rt_id,l_mirror_src_entity_result_id,'PRT') loop
10929: --
10930: l_table_route_id := null ;
10931: open ben_plan_design_program_module.g_table_route('PRT');
10932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10933: close ben_plan_design_program_module.g_table_route ;
10934: --
10935: l_information5 := l_prt_rec.mn_poe_num ||' - '|| l_prt_rec.mx_poe_num ||
10936: ' ' || hr_general.decode_lookup('BEN_NNMNTRY_UOM',l_prt_rec.poe_nnmntry_uom);
10929: --
10930: l_table_route_id := null ;
10931: open ben_plan_design_program_module.g_table_route('PRT');
10932: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
10933: close ben_plan_design_program_module.g_table_route ;
10934: --
10935: l_information5 := l_prt_rec.mn_poe_num ||' - '|| l_prt_rec.mx_poe_num ||
10936: ' ' || hr_general.decode_lookup('BEN_NNMNTRY_UOM',l_prt_rec.poe_nnmntry_uom);
10937: --'Intersection';
11023: ---------------------------------------------------------------
11024:
11025: if l_prt_rec.rndg_rl is not null then
11026: --
11027: ben_plan_design_program_module.create_formula_result
11028: (
11029: p_validate => 0
11030: ,p_copy_entity_result_id => l_copy_entity_result_id
11031: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11058: --
11059: for l_pgr_rec in c_pgr(l_parent_rec.ppl_grp_rt_id,l_mirror_src_entity_result_id,'PGR') loop
11060: --
11061: l_table_route_id := null ;
11062: open ben_plan_design_program_module.g_table_route('PGR');
11063: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11064: close ben_plan_design_program_module.g_table_route ;
11065: --
11066: l_information5 := ben_plan_design_program_module.get_people_group_name(l_pgr_rec.people_group_id)
11059: for l_pgr_rec in c_pgr(l_parent_rec.ppl_grp_rt_id,l_mirror_src_entity_result_id,'PGR') loop
11060: --
11061: l_table_route_id := null ;
11062: open ben_plan_design_program_module.g_table_route('PGR');
11063: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11064: close ben_plan_design_program_module.g_table_route ;
11065: --
11066: l_information5 := ben_plan_design_program_module.get_people_group_name(l_pgr_rec.people_group_id)
11067: || ben_plan_design_program_module.get_exclude_message(l_pgr_rec.excld_flag);
11060: --
11061: l_table_route_id := null ;
11062: open ben_plan_design_program_module.g_table_route('PGR');
11063: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11064: close ben_plan_design_program_module.g_table_route ;
11065: --
11066: l_information5 := ben_plan_design_program_module.get_people_group_name(l_pgr_rec.people_group_id)
11067: || ben_plan_design_program_module.get_exclude_message(l_pgr_rec.excld_flag);
11068: --'Intersection';
11062: open ben_plan_design_program_module.g_table_route('PGR');
11063: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11064: close ben_plan_design_program_module.g_table_route ;
11065: --
11066: l_information5 := ben_plan_design_program_module.get_people_group_name(l_pgr_rec.people_group_id)
11067: || ben_plan_design_program_module.get_exclude_message(l_pgr_rec.excld_flag);
11068: --'Intersection';
11069: --
11070: if p_effective_date between l_pgr_rec.effective_start_date
11063: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11064: close ben_plan_design_program_module.g_table_route ;
11065: --
11066: l_information5 := ben_plan_design_program_module.get_people_group_name(l_pgr_rec.people_group_id)
11067: || ben_plan_design_program_module.get_exclude_message(l_pgr_rec.excld_flag);
11068: --'Intersection';
11069: --
11070: if p_effective_date between l_pgr_rec.effective_start_date
11071: and l_pgr_rec.effective_end_date then
11161: --
11162: for l_pzr_rec in c_pzr(l_parent_rec.pstl_zip_rt_id,l_mirror_src_entity_result_id,'PZR') loop
11163: --
11164: l_table_route_id := null ;
11165: open ben_plan_design_program_module.g_table_route('PZR');
11166: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11167: close ben_plan_design_program_module.g_table_route ;
11168: --
11169: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_pzr_rec.pstl_zip_rng_id
11162: for l_pzr_rec in c_pzr(l_parent_rec.pstl_zip_rt_id,l_mirror_src_entity_result_id,'PZR') loop
11163: --
11164: l_table_route_id := null ;
11165: open ben_plan_design_program_module.g_table_route('PZR');
11166: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11167: close ben_plan_design_program_module.g_table_route ;
11168: --
11169: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_pzr_rec.pstl_zip_rng_id
11170: ,p_effective_date)
11163: --
11164: l_table_route_id := null ;
11165: open ben_plan_design_program_module.g_table_route('PZR');
11166: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11167: close ben_plan_design_program_module.g_table_route ;
11168: --
11169: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_pzr_rec.pstl_zip_rng_id
11170: ,p_effective_date)
11171: || ben_plan_design_program_module.get_exclude_message(l_pzr_rec.excld_flag);
11165: open ben_plan_design_program_module.g_table_route('PZR');
11166: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11167: close ben_plan_design_program_module.g_table_route ;
11168: --
11169: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_pzr_rec.pstl_zip_rng_id
11170: ,p_effective_date)
11171: || ben_plan_design_program_module.get_exclude_message(l_pzr_rec.excld_flag);
11172: --'Intersection';
11173: --
11167: close ben_plan_design_program_module.g_table_route ;
11168: --
11169: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_pzr_rec.pstl_zip_rng_id
11170: ,p_effective_date)
11171: || ben_plan_design_program_module.get_exclude_message(l_pzr_rec.excld_flag);
11172: --'Intersection';
11173: --
11174: if p_effective_date between l_pzr_rec.effective_start_date
11175: and l_pzr_rec.effective_end_date then
11280: hr_utility.set_location('l_pyrl_rt_id '||l_pyrl_rt_id,100);
11281: for l_pr__rec in c_pr_(l_parent_rec.pyrl_rt_id,l_mirror_src_entity_result_id,'PR_') loop
11282: --
11283: l_table_route_id := null ;
11284: open ben_plan_design_program_module.g_table_route('PR_');
11285: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11286: close ben_plan_design_program_module.g_table_route ;
11287: --
11288: l_information5 := ben_plan_design_program_module.get_payroll_name(l_pr__rec.payroll_id
11281: for l_pr__rec in c_pr_(l_parent_rec.pyrl_rt_id,l_mirror_src_entity_result_id,'PR_') loop
11282: --
11283: l_table_route_id := null ;
11284: open ben_plan_design_program_module.g_table_route('PR_');
11285: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11286: close ben_plan_design_program_module.g_table_route ;
11287: --
11288: l_information5 := ben_plan_design_program_module.get_payroll_name(l_pr__rec.payroll_id
11289: ,p_effective_date)
11282: --
11283: l_table_route_id := null ;
11284: open ben_plan_design_program_module.g_table_route('PR_');
11285: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11286: close ben_plan_design_program_module.g_table_route ;
11287: --
11288: l_information5 := ben_plan_design_program_module.get_payroll_name(l_pr__rec.payroll_id
11289: ,p_effective_date)
11290: || ben_plan_design_program_module.get_exclude_message(l_pr__rec.excld_flag);
11284: open ben_plan_design_program_module.g_table_route('PR_');
11285: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11286: close ben_plan_design_program_module.g_table_route ;
11287: --
11288: l_information5 := ben_plan_design_program_module.get_payroll_name(l_pr__rec.payroll_id
11289: ,p_effective_date)
11290: || ben_plan_design_program_module.get_exclude_message(l_pr__rec.excld_flag);
11291: --'Intersection';
11292: --
11286: close ben_plan_design_program_module.g_table_route ;
11287: --
11288: l_information5 := ben_plan_design_program_module.get_payroll_name(l_pr__rec.payroll_id
11289: ,p_effective_date)
11290: || ben_plan_design_program_module.get_exclude_message(l_pr__rec.excld_flag);
11291: --'Intersection';
11292: --
11293: if p_effective_date between l_pr__rec.effective_start_date
11294: and l_pr__rec.effective_end_date then
11430: hr_utility.set_location('l_py_bss_rt_id '||l_py_bss_rt_id,100);
11431: for l_pbr_rec in c_pbr(l_parent_rec.py_bss_rt_id,l_mirror_src_entity_result_id,'PBR') loop
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('PBR');
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 := ben_plan_design_program_module.get_pay_basis_name(l_pbr_rec.pay_basis_id)
11431: for l_pbr_rec in c_pbr(l_parent_rec.py_bss_rt_id,l_mirror_src_entity_result_id,'PBR') loop
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('PBR');
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 := ben_plan_design_program_module.get_pay_basis_name(l_pbr_rec.pay_basis_id)
11439: || ben_plan_design_program_module.get_exclude_message(l_pbr_rec.excld_flag);
11432: --
11433: l_table_route_id := null ;
11434: open ben_plan_design_program_module.g_table_route('PBR');
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 := ben_plan_design_program_module.get_pay_basis_name(l_pbr_rec.pay_basis_id)
11439: || ben_plan_design_program_module.get_exclude_message(l_pbr_rec.excld_flag);
11440: --'Intersection';
11434: open ben_plan_design_program_module.g_table_route('PBR');
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 := ben_plan_design_program_module.get_pay_basis_name(l_pbr_rec.pay_basis_id)
11439: || ben_plan_design_program_module.get_exclude_message(l_pbr_rec.excld_flag);
11440: --'Intersection';
11441: --
11442: if p_effective_date between l_pbr_rec.effective_start_date
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 := ben_plan_design_program_module.get_pay_basis_name(l_pbr_rec.pay_basis_id)
11439: || ben_plan_design_program_module.get_exclude_message(l_pbr_rec.excld_flag);
11440: --'Intersection';
11441: --
11442: if p_effective_date between l_pbr_rec.effective_start_date
11443: and l_pbr_rec.effective_end_date then
11567: --
11568: for l_shr_rec in c_shr(l_parent_rec.schedd_hrs_rt_id,l_mirror_src_entity_result_id,'SHR') loop
11569: --
11570: l_table_route_id := null ;
11571: open ben_plan_design_program_module.g_table_route('SHR');
11572: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11573: close ben_plan_design_program_module.g_table_route ;
11574: --
11575: l_information5 := l_shr_rec.hrs_num ||' - ' || l_shr_rec.max_hrs_num ||' '||
11568: for l_shr_rec in c_shr(l_parent_rec.schedd_hrs_rt_id,l_mirror_src_entity_result_id,'SHR') loop
11569: --
11570: l_table_route_id := null ;
11571: open ben_plan_design_program_module.g_table_route('SHR');
11572: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11573: close ben_plan_design_program_module.g_table_route ;
11574: --
11575: l_information5 := l_shr_rec.hrs_num ||' - ' || l_shr_rec.max_hrs_num ||' '||
11576: hr_general.decode_lookup('FREQUENCY',l_shr_rec.freq_cd)
11569: --
11570: l_table_route_id := null ;
11571: open ben_plan_design_program_module.g_table_route('SHR');
11572: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11573: close ben_plan_design_program_module.g_table_route ;
11574: --
11575: l_information5 := l_shr_rec.hrs_num ||' - ' || l_shr_rec.max_hrs_num ||' '||
11576: hr_general.decode_lookup('FREQUENCY',l_shr_rec.freq_cd)
11577: || ben_plan_design_program_module.get_exclude_message(l_shr_rec.excld_flag); --'Intersection';
11573: close ben_plan_design_program_module.g_table_route ;
11574: --
11575: l_information5 := l_shr_rec.hrs_num ||' - ' || l_shr_rec.max_hrs_num ||' '||
11576: hr_general.decode_lookup('FREQUENCY',l_shr_rec.freq_cd)
11577: || ben_plan_design_program_module.get_exclude_message(l_shr_rec.excld_flag); --'Intersection';
11578: --
11579: if p_effective_date between l_shr_rec.effective_start_date
11580: and l_shr_rec.effective_end_date then
11581: --
11664: ---------------------------------------------------------------
11665: --
11666: if l_shr_rec.determination_rl is not null then
11667: --
11668: ben_plan_design_program_module.create_formula_result
11669: (
11670: p_validate => 0
11671: ,p_copy_entity_result_id => l_copy_entity_result_id
11672: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11686: ---------------------------------------------------------------
11687: --
11688: if l_shr_rec.rounding_rl is not null then
11689: --
11690: ben_plan_design_program_module.create_formula_result
11691: (
11692: p_validate => 0
11693: ,p_copy_entity_result_id => l_copy_entity_result_id
11694: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11706: ---------------------------------------------------------------
11707: --
11708: if l_shr_rec.schedd_hrs_rl is not null then
11709: --
11710: ben_plan_design_program_module.create_formula_result
11711: (
11712: p_validate => 0
11713: ,p_copy_entity_result_id => l_copy_entity_result_id
11714: ,p_copy_entity_txn_id => p_copy_entity_txn_id
11739: --
11740: for l_sar_rec in c_sar(l_parent_rec.svc_area_rt_id,l_mirror_src_entity_result_id,'SAR') loop
11741: --
11742: l_table_route_id := null ;
11743: open ben_plan_design_program_module.g_table_route('SAR');
11744: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11745: close ben_plan_design_program_module.g_table_route ;
11746: --
11747: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_sar_rec.svc_area_id
11740: for l_sar_rec in c_sar(l_parent_rec.svc_area_rt_id,l_mirror_src_entity_result_id,'SAR') loop
11741: --
11742: l_table_route_id := null ;
11743: open ben_plan_design_program_module.g_table_route('SAR');
11744: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11745: close ben_plan_design_program_module.g_table_route ;
11746: --
11747: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_sar_rec.svc_area_id
11748: ,p_effective_date)
11741: --
11742: l_table_route_id := null ;
11743: open ben_plan_design_program_module.g_table_route('SAR');
11744: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11745: close ben_plan_design_program_module.g_table_route ;
11746: --
11747: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_sar_rec.svc_area_id
11748: ,p_effective_date)
11749: || ben_plan_design_program_module.get_exclude_message(l_sar_rec.excld_flag);
11743: open ben_plan_design_program_module.g_table_route('SAR');
11744: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11745: close ben_plan_design_program_module.g_table_route ;
11746: --
11747: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_sar_rec.svc_area_id
11748: ,p_effective_date)
11749: || ben_plan_design_program_module.get_exclude_message(l_sar_rec.excld_flag);
11750: --'Intersection';
11751: --
11745: close ben_plan_design_program_module.g_table_route ;
11746: --
11747: l_information5 := ben_plan_design_program_module.get_svc_area_name(l_sar_rec.svc_area_id
11748: ,p_effective_date)
11749: || ben_plan_design_program_module.get_exclude_message(l_sar_rec.excld_flag);
11750: --'Intersection';
11751: --
11752: if p_effective_date between l_sar_rec.effective_start_date
11753: and l_sar_rec.effective_end_date then
11856: --
11857: for l_tur_rec in c_tur(l_parent_rec.tbco_use_rt_id,l_mirror_src_entity_result_id,'TUR') loop
11858: --
11859: l_table_route_id := null ;
11860: open ben_plan_design_program_module.g_table_route('TUR');
11861: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11862: close ben_plan_design_program_module.g_table_route ;
11863: --
11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)
11857: for l_tur_rec in c_tur(l_parent_rec.tbco_use_rt_id,l_mirror_src_entity_result_id,'TUR') loop
11858: --
11859: l_table_route_id := null ;
11860: open ben_plan_design_program_module.g_table_route('TUR');
11861: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11862: close ben_plan_design_program_module.g_table_route ;
11863: --
11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)
11865: || ben_plan_design_program_module.get_exclude_message(l_tur_rec.excld_flag);
11858: --
11859: l_table_route_id := null ;
11860: open ben_plan_design_program_module.g_table_route('TUR');
11861: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11862: close ben_plan_design_program_module.g_table_route ;
11863: --
11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)
11865: || ben_plan_design_program_module.get_exclude_message(l_tur_rec.excld_flag);
11866: --Intersection';
11861: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11862: close ben_plan_design_program_module.g_table_route ;
11863: --
11864: l_information5 := hr_general.decode_lookup('TOBACCO_USER',l_tur_rec.uses_tbco_flag)
11865: || ben_plan_design_program_module.get_exclude_message(l_tur_rec.excld_flag);
11866: --Intersection';
11867: --
11868: if p_effective_date between l_tur_rec.effective_start_date
11869: and l_tur_rec.effective_end_date then
11959: --
11960: for l_tcv_rec in c_tcv(l_parent_rec.ttl_cvg_vol_rt_id,l_mirror_src_entity_result_id,'TCV') loop
11961: --
11962: l_table_route_id := null ;
11963: open ben_plan_design_program_module.g_table_route('TCV');
11964: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11965: close ben_plan_design_program_module.g_table_route ;
11966: --
11967: l_information5 := l_tcv_rec.mn_cvg_vol_amt || ' - ' ||l_tcv_rec.mx_cvg_vol_amt
11960: for l_tcv_rec in c_tcv(l_parent_rec.ttl_cvg_vol_rt_id,l_mirror_src_entity_result_id,'TCV') loop
11961: --
11962: l_table_route_id := null ;
11963: open ben_plan_design_program_module.g_table_route('TCV');
11964: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11965: close ben_plan_design_program_module.g_table_route ;
11966: --
11967: l_information5 := l_tcv_rec.mn_cvg_vol_amt || ' - ' ||l_tcv_rec.mx_cvg_vol_amt
11968: || ben_plan_design_program_module.get_exclude_message(l_tcv_rec.excld_flag);
11961: --
11962: l_table_route_id := null ;
11963: open ben_plan_design_program_module.g_table_route('TCV');
11964: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11965: close ben_plan_design_program_module.g_table_route ;
11966: --
11967: l_information5 := l_tcv_rec.mn_cvg_vol_amt || ' - ' ||l_tcv_rec.mx_cvg_vol_amt
11968: || ben_plan_design_program_module.get_exclude_message(l_tcv_rec.excld_flag);
11969: --'Intersection';
11964: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
11965: close ben_plan_design_program_module.g_table_route ;
11966: --
11967: l_information5 := l_tcv_rec.mn_cvg_vol_amt || ' - ' ||l_tcv_rec.mx_cvg_vol_amt
11968: || ben_plan_design_program_module.get_exclude_message(l_tcv_rec.excld_flag);
11969: --'Intersection';
11970: --
11971: if p_effective_date between l_tcv_rec.effective_start_date
11972: and l_tcv_rec.effective_end_date then
12055: ---------------------------------------------------------------
12056:
12057: if l_tcv_rec.cvg_vol_det_rl is not null then
12058: --
12059: ben_plan_design_program_module.create_formula_result
12060: (
12061: p_validate => 0
12062: ,p_copy_entity_result_id => l_copy_entity_result_id
12063: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12089: --
12090: for l_ttp_rec in c_ttp(l_parent_rec.ttl_prtt_rt_id,l_mirror_src_entity_result_id,'TTP') loop
12091: --
12092: l_table_route_id := null ;
12093: open ben_plan_design_program_module.g_table_route('TTP');
12094: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12095: close ben_plan_design_program_module.g_table_route ;
12096: --
12097: l_information5 := l_ttp_rec.mn_prtt_num ||' - '||l_ttp_rec.mx_prtt_num
12090: for l_ttp_rec in c_ttp(l_parent_rec.ttl_prtt_rt_id,l_mirror_src_entity_result_id,'TTP') loop
12091: --
12092: l_table_route_id := null ;
12093: open ben_plan_design_program_module.g_table_route('TTP');
12094: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12095: close ben_plan_design_program_module.g_table_route ;
12096: --
12097: l_information5 := l_ttp_rec.mn_prtt_num ||' - '||l_ttp_rec.mx_prtt_num
12098: || ben_plan_design_program_module.get_exclude_message(l_ttp_rec.excld_flag);
12091: --
12092: l_table_route_id := null ;
12093: open ben_plan_design_program_module.g_table_route('TTP');
12094: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12095: close ben_plan_design_program_module.g_table_route ;
12096: --
12097: l_information5 := l_ttp_rec.mn_prtt_num ||' - '||l_ttp_rec.mx_prtt_num
12098: || ben_plan_design_program_module.get_exclude_message(l_ttp_rec.excld_flag);
12099: --'Intersection';
12094: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12095: close ben_plan_design_program_module.g_table_route ;
12096: --
12097: l_information5 := l_ttp_rec.mn_prtt_num ||' - '||l_ttp_rec.mx_prtt_num
12098: || ben_plan_design_program_module.get_exclude_message(l_ttp_rec.excld_flag);
12099: --'Intersection';
12100: --
12101: if p_effective_date between l_ttp_rec.effective_start_date
12102: and l_ttp_rec.effective_end_date then
12185: ---------------------------------------------------------------
12186:
12187: if l_ttp_rec.prtt_det_rl is not null then
12188: --
12189: ben_plan_design_program_module.create_formula_result
12190: (
12191: p_validate => 0
12192: ,p_copy_entity_result_id => l_copy_entity_result_id
12193: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12219: --
12220: for l_vmr_rec in c_vmr(l_parent_rec.vrbl_mtchg_rt_id,l_mirror_src_entity_result_id,'VMR') loop
12221: --
12222: l_table_route_id := null ;
12223: open ben_plan_design_program_module.g_table_route('VMR');
12224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12225: close ben_plan_design_program_module.g_table_route ;
12226: --
12227: l_information5 := l_vmr_rec.from_pct_val ||' - '|| l_vmr_rec.to_pct_val; --'Intersection';
12220: for l_vmr_rec in c_vmr(l_parent_rec.vrbl_mtchg_rt_id,l_mirror_src_entity_result_id,'VMR') loop
12221: --
12222: l_table_route_id := null ;
12223: open ben_plan_design_program_module.g_table_route('VMR');
12224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12225: close ben_plan_design_program_module.g_table_route ;
12226: --
12227: l_information5 := l_vmr_rec.from_pct_val ||' - '|| l_vmr_rec.to_pct_val; --'Intersection';
12228: --
12221: --
12222: l_table_route_id := null ;
12223: open ben_plan_design_program_module.g_table_route('VMR');
12224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12225: close ben_plan_design_program_module.g_table_route ;
12226: --
12227: l_information5 := l_vmr_rec.from_pct_val ||' - '|| l_vmr_rec.to_pct_val; --'Intersection';
12228: --
12229: if p_effective_date between l_vmr_rec.effective_start_date
12318: ---------------------------------------------------------------
12319:
12320: if l_vmr_rec.mtchg_rt_calc_rl is not null then
12321: --
12322: ben_plan_design_program_module.create_formula_result
12323: (
12324: p_validate => 0
12325: ,p_copy_entity_result_id => l_copy_entity_result_id
12326: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12352: --
12353: for l_vpr_rec in c_vpr(l_parent_rec.vrbl_rt_prfl_rl_id,l_mirror_src_entity_result_id,'VPR') loop
12354: --
12355: l_table_route_id := null ;
12356: open ben_plan_design_program_module.g_table_route('VPR');
12357: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12358: close ben_plan_design_program_module.g_table_route ;
12359: --
12360: l_information5 := ben_plan_design_program_module.get_formula_name(l_vpr_rec.formula_id,p_effective_date);
12353: for l_vpr_rec in c_vpr(l_parent_rec.vrbl_rt_prfl_rl_id,l_mirror_src_entity_result_id,'VPR') loop
12354: --
12355: l_table_route_id := null ;
12356: open ben_plan_design_program_module.g_table_route('VPR');
12357: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12358: close ben_plan_design_program_module.g_table_route ;
12359: --
12360: l_information5 := ben_plan_design_program_module.get_formula_name(l_vpr_rec.formula_id,p_effective_date);
12361: --'Intersection';
12354: --
12355: l_table_route_id := null ;
12356: open ben_plan_design_program_module.g_table_route('VPR');
12357: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12358: close ben_plan_design_program_module.g_table_route ;
12359: --
12360: l_information5 := ben_plan_design_program_module.get_formula_name(l_vpr_rec.formula_id,p_effective_date);
12361: --'Intersection';
12362: --
12356: open ben_plan_design_program_module.g_table_route('VPR');
12357: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12358: close ben_plan_design_program_module.g_table_route ;
12359: --
12360: l_information5 := ben_plan_design_program_module.get_formula_name(l_vpr_rec.formula_id,p_effective_date);
12361: --'Intersection';
12362: --
12363: if p_effective_date between l_vpr_rec.effective_start_date
12364: and l_vpr_rec.effective_end_date then
12442: ---------------------------------------------------------------
12443:
12444: if l_vpr_rec.formula_id is not null then
12445: --
12446: ben_plan_design_program_module.create_formula_result
12447: (
12448: p_validate => 0
12449: ,p_copy_entity_result_id => l_copy_entity_result_id
12450: ,p_copy_entity_txn_id => p_copy_entity_txn_id
12476: --
12477: for l_wlr_rec in c_wlr(l_parent_rec.wk_loc_rt_id,l_mirror_src_entity_result_id,'WLR') loop
12478: --
12479: l_table_route_id := null ;
12480: open ben_plan_design_program_module.g_table_route('WLR');
12481: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12482: close ben_plan_design_program_module.g_table_route ;
12483: --
12484: l_information5 := ben_plan_design_program_module.get_location_name(l_wlr_rec.location_id)
12477: for l_wlr_rec in c_wlr(l_parent_rec.wk_loc_rt_id,l_mirror_src_entity_result_id,'WLR') loop
12478: --
12479: l_table_route_id := null ;
12480: open ben_plan_design_program_module.g_table_route('WLR');
12481: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12482: close ben_plan_design_program_module.g_table_route ;
12483: --
12484: l_information5 := ben_plan_design_program_module.get_location_name(l_wlr_rec.location_id)
12485: || ben_plan_design_program_module.get_exclude_message(l_wlr_rec.excld_flag);
12478: --
12479: l_table_route_id := null ;
12480: open ben_plan_design_program_module.g_table_route('WLR');
12481: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12482: close ben_plan_design_program_module.g_table_route ;
12483: --
12484: l_information5 := ben_plan_design_program_module.get_location_name(l_wlr_rec.location_id)
12485: || ben_plan_design_program_module.get_exclude_message(l_wlr_rec.excld_flag);
12486: -- 'Intersection';
12480: open ben_plan_design_program_module.g_table_route('WLR');
12481: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12482: close ben_plan_design_program_module.g_table_route ;
12483: --
12484: l_information5 := ben_plan_design_program_module.get_location_name(l_wlr_rec.location_id)
12485: || ben_plan_design_program_module.get_exclude_message(l_wlr_rec.excld_flag);
12486: -- 'Intersection';
12487: --
12488: if p_effective_date between l_wlr_rec.effective_start_date
12481: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12482: close ben_plan_design_program_module.g_table_route ;
12483: --
12484: l_information5 := ben_plan_design_program_module.get_location_name(l_wlr_rec.location_id)
12485: || ben_plan_design_program_module.get_exclude_message(l_wlr_rec.excld_flag);
12486: -- 'Intersection';
12487: --
12488: if p_effective_date between l_wlr_rec.effective_start_date
12489: and l_wlr_rec.effective_end_date then
12623: --
12624: for l_cty_rec in c_cty(l_parent_rec.comptncy_rt_id,l_mirror_src_entity_result_id,'CTY') loop
12625: --
12626: l_table_route_id := null ;
12627: open ben_plan_design_program_module.g_table_route('CTY');
12628: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12629: close ben_plan_design_program_module.g_table_route ;
12630: --
12631: l_information5 := ben_plan_design_program_module.get_competence_rating_name
12624: for l_cty_rec in c_cty(l_parent_rec.comptncy_rt_id,l_mirror_src_entity_result_id,'CTY') loop
12625: --
12626: l_table_route_id := null ;
12627: open ben_plan_design_program_module.g_table_route('CTY');
12628: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12629: close ben_plan_design_program_module.g_table_route ;
12630: --
12631: l_information5 := ben_plan_design_program_module.get_competence_rating_name
12632: (l_cty_rec.competence_id
12625: --
12626: l_table_route_id := null ;
12627: open ben_plan_design_program_module.g_table_route('CTY');
12628: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12629: close ben_plan_design_program_module.g_table_route ;
12630: --
12631: l_information5 := ben_plan_design_program_module.get_competence_rating_name
12632: (l_cty_rec.competence_id
12633: ,l_cty_rec.rating_level_id)
12627: open ben_plan_design_program_module.g_table_route('CTY');
12628: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12629: close ben_plan_design_program_module.g_table_route ;
12630: --
12631: l_information5 := ben_plan_design_program_module.get_competence_rating_name
12632: (l_cty_rec.competence_id
12633: ,l_cty_rec.rating_level_id)
12634: || ben_plan_design_program_module.get_exclude_message(l_cty_rec.excld_flag);
12635: -- 'Intersection';
12630: --
12631: l_information5 := ben_plan_design_program_module.get_competence_rating_name
12632: (l_cty_rec.competence_id
12633: ,l_cty_rec.rating_level_id)
12634: || ben_plan_design_program_module.get_exclude_message(l_cty_rec.excld_flag);
12635: -- 'Intersection';
12636: --
12637: if p_effective_date between l_cty_rec.effective_start_date
12638: and l_cty_rec.effective_end_date then
12791: --
12792: for l_jrt_rec in c_jrt(l_parent_rec.job_rt_id,l_mirror_src_entity_result_id,'JRT') loop
12793: --
12794: l_table_route_id := null ;
12795: open ben_plan_design_program_module.g_table_route('JRT');
12796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12797: close ben_plan_design_program_module.g_table_route ;
12798: --
12799: l_information5 := ben_plan_design_program_module.get_job_name(l_jrt_rec.job_id)
12792: for l_jrt_rec in c_jrt(l_parent_rec.job_rt_id,l_mirror_src_entity_result_id,'JRT') loop
12793: --
12794: l_table_route_id := null ;
12795: open ben_plan_design_program_module.g_table_route('JRT');
12796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12797: close ben_plan_design_program_module.g_table_route ;
12798: --
12799: l_information5 := ben_plan_design_program_module.get_job_name(l_jrt_rec.job_id)
12800: || ben_plan_design_program_module.get_exclude_message(l_jrt_rec.excld_flag);
12793: --
12794: l_table_route_id := null ;
12795: open ben_plan_design_program_module.g_table_route('JRT');
12796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12797: close ben_plan_design_program_module.g_table_route ;
12798: --
12799: l_information5 := ben_plan_design_program_module.get_job_name(l_jrt_rec.job_id)
12800: || ben_plan_design_program_module.get_exclude_message(l_jrt_rec.excld_flag);
12801: --'Intersection';
12795: open ben_plan_design_program_module.g_table_route('JRT');
12796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12797: close ben_plan_design_program_module.g_table_route ;
12798: --
12799: l_information5 := ben_plan_design_program_module.get_job_name(l_jrt_rec.job_id)
12800: || ben_plan_design_program_module.get_exclude_message(l_jrt_rec.excld_flag);
12801: --'Intersection';
12802: --
12803: if p_effective_date between l_jrt_rec.effective_start_date
12796: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12797: close ben_plan_design_program_module.g_table_route ;
12798: --
12799: l_information5 := ben_plan_design_program_module.get_job_name(l_jrt_rec.job_id)
12800: || ben_plan_design_program_module.get_exclude_message(l_jrt_rec.excld_flag);
12801: --'Intersection';
12802: --
12803: if p_effective_date between l_jrt_rec.effective_start_date
12804: and l_jrt_rec.effective_end_date then
12940: --
12941: for l_pst_rec in c_pst(l_parent_rec.pstn_rt_id,l_mirror_src_entity_result_id,'PST') loop
12942: --
12943: l_table_route_id := null ;
12944: open ben_plan_design_program_module.g_table_route('PST');
12945: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12946: close ben_plan_design_program_module.g_table_route ;
12947: --
12948: l_information5 := ben_plan_design_program_module.get_position_name(l_pst_rec.position_id)
12941: for l_pst_rec in c_pst(l_parent_rec.pstn_rt_id,l_mirror_src_entity_result_id,'PST') loop
12942: --
12943: l_table_route_id := null ;
12944: open ben_plan_design_program_module.g_table_route('PST');
12945: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12946: close ben_plan_design_program_module.g_table_route ;
12947: --
12948: l_information5 := ben_plan_design_program_module.get_position_name(l_pst_rec.position_id)
12949: || ben_plan_design_program_module.get_exclude_message(l_pst_rec.excld_flag);
12942: --
12943: l_table_route_id := null ;
12944: open ben_plan_design_program_module.g_table_route('PST');
12945: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12946: close ben_plan_design_program_module.g_table_route ;
12947: --
12948: l_information5 := ben_plan_design_program_module.get_position_name(l_pst_rec.position_id)
12949: || ben_plan_design_program_module.get_exclude_message(l_pst_rec.excld_flag);
12950: --'Intersection';
12944: open ben_plan_design_program_module.g_table_route('PST');
12945: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12946: close ben_plan_design_program_module.g_table_route ;
12947: --
12948: l_information5 := ben_plan_design_program_module.get_position_name(l_pst_rec.position_id)
12949: || ben_plan_design_program_module.get_exclude_message(l_pst_rec.excld_flag);
12950: --'Intersection';
12951: --
12952: if p_effective_date between l_pst_rec.effective_start_date
12945: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
12946: close ben_plan_design_program_module.g_table_route ;
12947: --
12948: l_information5 := ben_plan_design_program_module.get_position_name(l_pst_rec.position_id)
12949: || ben_plan_design_program_module.get_exclude_message(l_pst_rec.excld_flag);
12950: --'Intersection';
12951: --
12952: if p_effective_date between l_pst_rec.effective_start_date
12953: and l_pst_rec.effective_end_date then
13088: --
13089: for l_qtr_rec in c_qtr(l_parent_rec.qual_titl_rt_id,l_mirror_src_entity_result_id,'QTR') loop
13090: --
13091: l_table_route_id := null ;
13092: open ben_plan_design_program_module.g_table_route('QTR');
13093: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13094: close ben_plan_design_program_module.g_table_route ;
13095: --
13096: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_qtr_rec.qualification_type_id)
13089: for l_qtr_rec in c_qtr(l_parent_rec.qual_titl_rt_id,l_mirror_src_entity_result_id,'QTR') loop
13090: --
13091: l_table_route_id := null ;
13092: open ben_plan_design_program_module.g_table_route('QTR');
13093: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13094: close ben_plan_design_program_module.g_table_route ;
13095: --
13096: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_qtr_rec.qualification_type_id)
13097: || ben_plan_design_program_module.get_exclude_message(l_qtr_rec.excld_flag);
13090: --
13091: l_table_route_id := null ;
13092: open ben_plan_design_program_module.g_table_route('QTR');
13093: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13094: close ben_plan_design_program_module.g_table_route ;
13095: --
13096: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_qtr_rec.qualification_type_id)
13097: || ben_plan_design_program_module.get_exclude_message(l_qtr_rec.excld_flag);
13098: --'Intersection';
13092: open ben_plan_design_program_module.g_table_route('QTR');
13093: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13094: close ben_plan_design_program_module.g_table_route ;
13095: --
13096: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_qtr_rec.qualification_type_id)
13097: || ben_plan_design_program_module.get_exclude_message(l_qtr_rec.excld_flag);
13098: --'Intersection';
13099: --
13100: if p_effective_date between l_qtr_rec.effective_start_date
13093: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13094: close ben_plan_design_program_module.g_table_route ;
13095: --
13096: l_information5 := ben_plan_design_program_module.get_qual_type_name(l_qtr_rec.qualification_type_id)
13097: || ben_plan_design_program_module.get_exclude_message(l_qtr_rec.excld_flag);
13098: --'Intersection';
13099: --
13100: if p_effective_date between l_qtr_rec.effective_start_date
13101: and l_qtr_rec.effective_end_date then
13226: --
13227: for l_cqr_rec in c_cqr(l_parent_rec.cbr_quald_bnf_rt_id,l_mirror_src_entity_result_id,'CQR') loop
13228: --
13229: l_table_route_id := null ;
13230: open ben_plan_design_program_module.g_table_route('CQR');
13231: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13232: close ben_plan_design_program_module.g_table_route ;
13233: --
13234: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_cqr_rec.ptip_id
13227: for l_cqr_rec in c_cqr(l_parent_rec.cbr_quald_bnf_rt_id,l_mirror_src_entity_result_id,'CQR') loop
13228: --
13229: l_table_route_id := null ;
13230: open ben_plan_design_program_module.g_table_route('CQR');
13231: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13232: close ben_plan_design_program_module.g_table_route ;
13233: --
13234: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_cqr_rec.ptip_id
13235: ,l_cqr_rec.pgm_id
13228: --
13229: l_table_route_id := null ;
13230: open ben_plan_design_program_module.g_table_route('CQR');
13231: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13232: close ben_plan_design_program_module.g_table_route ;
13233: --
13234: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_cqr_rec.ptip_id
13235: ,l_cqr_rec.pgm_id
13236: ,p_effective_date);
13230: open ben_plan_design_program_module.g_table_route('CQR');
13231: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13232: close ben_plan_design_program_module.g_table_route ;
13233: --
13234: l_information5 := ben_plan_design_program_module.get_cbr_quald_bnf_name(l_cqr_rec.ptip_id
13235: ,l_cqr_rec.pgm_id
13236: ,p_effective_date);
13237: --'Intersection';
13238: --
13328: --
13329: for l_cpn_rec in c_cpn(l_parent_rec.cntng_prtn_prfl_rt_id,l_mirror_src_entity_result_id,'CPN') loop
13330: --
13331: l_table_route_id := null ;
13332: open ben_plan_design_program_module.g_table_route('CPN');
13333: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13334: close ben_plan_design_program_module.g_table_route ;
13335: --
13336: l_information5 := l_cpn_rec.pymt_must_be_rcvd_num ||' '||
13329: for l_cpn_rec in c_cpn(l_parent_rec.cntng_prtn_prfl_rt_id,l_mirror_src_entity_result_id,'CPN') loop
13330: --
13331: l_table_route_id := null ;
13332: open ben_plan_design_program_module.g_table_route('CPN');
13333: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13334: close ben_plan_design_program_module.g_table_route ;
13335: --
13336: l_information5 := l_cpn_rec.pymt_must_be_rcvd_num ||' '||
13337: hr_general.decode_lookup('BEN_TM_UOM', l_cpn_rec.pymt_must_be_rcvd_uom);
13330: --
13331: l_table_route_id := null ;
13332: open ben_plan_design_program_module.g_table_route('CPN');
13333: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13334: close ben_plan_design_program_module.g_table_route ;
13335: --
13336: l_information5 := l_cpn_rec.pymt_must_be_rcvd_num ||' '||
13337: hr_general.decode_lookup('BEN_TM_UOM', l_cpn_rec.pymt_must_be_rcvd_uom);
13338: --'Intersection';
13417: ---------------------------------------------------------------
13418:
13419: if l_cpn_rec.pymt_must_be_rcvd_rl is not null then
13420: --
13421: ben_plan_design_program_module.create_formula_result
13422: (
13423: p_validate => 0
13424: ,p_copy_entity_result_id => l_copy_entity_result_id
13425: ,p_copy_entity_txn_id => p_copy_entity_txn_id
13451: --
13452: for l_dcl_rec in c_dcl(l_parent_rec.dpnt_cvrd_othr_pl_rt_id,l_mirror_src_entity_result_id,'DCL') loop
13453: --
13454: l_table_route_id := null ;
13455: open ben_plan_design_program_module.g_table_route('DCL');
13456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13457: close ben_plan_design_program_module.g_table_route ;
13458: --
13459: l_information5 := ben_plan_design_program_module.get_pl_name(l_dcl_rec.pl_id,p_effective_date)
13452: for l_dcl_rec in c_dcl(l_parent_rec.dpnt_cvrd_othr_pl_rt_id,l_mirror_src_entity_result_id,'DCL') loop
13453: --
13454: l_table_route_id := null ;
13455: open ben_plan_design_program_module.g_table_route('DCL');
13456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13457: close ben_plan_design_program_module.g_table_route ;
13458: --
13459: l_information5 := ben_plan_design_program_module.get_pl_name(l_dcl_rec.pl_id,p_effective_date)
13460: || ben_plan_design_program_module.get_exclude_message(l_dcl_rec.excld_flag);
13453: --
13454: l_table_route_id := null ;
13455: open ben_plan_design_program_module.g_table_route('DCL');
13456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13457: close ben_plan_design_program_module.g_table_route ;
13458: --
13459: l_information5 := ben_plan_design_program_module.get_pl_name(l_dcl_rec.pl_id,p_effective_date)
13460: || ben_plan_design_program_module.get_exclude_message(l_dcl_rec.excld_flag);
13461: --'Intersection';
13455: open ben_plan_design_program_module.g_table_route('DCL');
13456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13457: close ben_plan_design_program_module.g_table_route ;
13458: --
13459: l_information5 := ben_plan_design_program_module.get_pl_name(l_dcl_rec.pl_id,p_effective_date)
13460: || ben_plan_design_program_module.get_exclude_message(l_dcl_rec.excld_flag);
13461: --'Intersection';
13462: --
13463: if p_effective_date between l_dcl_rec.effective_start_date
13456: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13457: close ben_plan_design_program_module.g_table_route ;
13458: --
13459: l_information5 := ben_plan_design_program_module.get_pl_name(l_dcl_rec.pl_id,p_effective_date)
13460: || ben_plan_design_program_module.get_exclude_message(l_dcl_rec.excld_flag);
13461: --'Intersection';
13462: --
13463: if p_effective_date between l_dcl_rec.effective_start_date
13464: and l_dcl_rec.effective_end_date then
13552: --
13553: for l_dcp_rec in c_dcp(l_parent_rec.dpnt_cvrd_plip_rt_id,l_mirror_src_entity_result_id,'DCP') loop
13554: --
13555: l_table_route_id := null ;
13556: open ben_plan_design_program_module.g_table_route('DCP');
13557: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13558: close ben_plan_design_program_module.g_table_route ;
13559: --
13560: l_information5 := ben_plan_design_program_module.get_plip_name(l_dcp_rec.plip_id,p_effective_date)
13553: for l_dcp_rec in c_dcp(l_parent_rec.dpnt_cvrd_plip_rt_id,l_mirror_src_entity_result_id,'DCP') loop
13554: --
13555: l_table_route_id := null ;
13556: open ben_plan_design_program_module.g_table_route('DCP');
13557: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13558: close ben_plan_design_program_module.g_table_route ;
13559: --
13560: l_information5 := ben_plan_design_program_module.get_plip_name(l_dcp_rec.plip_id,p_effective_date)
13561: || ben_plan_design_program_module.get_exclude_message(l_dcp_rec.excld_flag);
13554: --
13555: l_table_route_id := null ;
13556: open ben_plan_design_program_module.g_table_route('DCP');
13557: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13558: close ben_plan_design_program_module.g_table_route ;
13559: --
13560: l_information5 := ben_plan_design_program_module.get_plip_name(l_dcp_rec.plip_id,p_effective_date)
13561: || ben_plan_design_program_module.get_exclude_message(l_dcp_rec.excld_flag);
13562: --'Intersection';
13556: open ben_plan_design_program_module.g_table_route('DCP');
13557: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13558: close ben_plan_design_program_module.g_table_route ;
13559: --
13560: l_information5 := ben_plan_design_program_module.get_plip_name(l_dcp_rec.plip_id,p_effective_date)
13561: || ben_plan_design_program_module.get_exclude_message(l_dcp_rec.excld_flag);
13562: --'Intersection';
13563: --
13564: if p_effective_date between l_dcp_rec.effective_start_date
13557: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13558: close ben_plan_design_program_module.g_table_route ;
13559: --
13560: l_information5 := ben_plan_design_program_module.get_plip_name(l_dcp_rec.plip_id,p_effective_date)
13561: || ben_plan_design_program_module.get_exclude_message(l_dcp_rec.excld_flag);
13562: --'Intersection';
13563: --
13564: if p_effective_date between l_dcp_rec.effective_start_date
13565: and l_dcp_rec.effective_end_date then
13654: --
13655: for l_dco_rec in c_dco(l_parent_rec.dpnt_cvrd_othr_ptip_rt_id,l_mirror_src_entity_result_id,'DCO') loop
13656: --
13657: l_table_route_id := null ;
13658: open ben_plan_design_program_module.g_table_route('DCO');
13659: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13660: close ben_plan_design_program_module.g_table_route ;
13661: --
13662: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dco_rec.ptip_id,p_effective_date)
13655: for l_dco_rec in c_dco(l_parent_rec.dpnt_cvrd_othr_ptip_rt_id,l_mirror_src_entity_result_id,'DCO') loop
13656: --
13657: l_table_route_id := null ;
13658: open ben_plan_design_program_module.g_table_route('DCO');
13659: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13660: close ben_plan_design_program_module.g_table_route ;
13661: --
13662: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dco_rec.ptip_id,p_effective_date)
13663: || ben_plan_design_program_module.get_exclude_message(l_dco_rec.excld_flag);
13656: --
13657: l_table_route_id := null ;
13658: open ben_plan_design_program_module.g_table_route('DCO');
13659: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13660: close ben_plan_design_program_module.g_table_route ;
13661: --
13662: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dco_rec.ptip_id,p_effective_date)
13663: || ben_plan_design_program_module.get_exclude_message(l_dco_rec.excld_flag);
13664: --'Intersection';
13658: open ben_plan_design_program_module.g_table_route('DCO');
13659: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13660: close ben_plan_design_program_module.g_table_route ;
13661: --
13662: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dco_rec.ptip_id,p_effective_date)
13663: || ben_plan_design_program_module.get_exclude_message(l_dco_rec.excld_flag);
13664: --'Intersection';
13665: --
13666: if p_effective_date between l_dco_rec.effective_start_date
13659: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13660: close ben_plan_design_program_module.g_table_route ;
13661: --
13662: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dco_rec.ptip_id,p_effective_date)
13663: || ben_plan_design_program_module.get_exclude_message(l_dco_rec.excld_flag);
13664: --'Intersection';
13665: --
13666: if p_effective_date between l_dco_rec.effective_start_date
13667: and l_dco_rec.effective_end_date then
13756: --
13757: for l_dop_rec in c_dop(l_parent_rec.dpnt_cvrd_othr_pgm_rt_id,l_mirror_src_entity_result_id,'DOP') loop
13758: --
13759: l_table_route_id := null ;
13760: open ben_plan_design_program_module.g_table_route('DOP');
13761: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13762: close ben_plan_design_program_module.g_table_route ;
13763: --
13764: l_information5 := ben_plan_design_program_module.get_pgm_name(l_dop_rec.pgm_id,p_effective_date)
13757: for l_dop_rec in c_dop(l_parent_rec.dpnt_cvrd_othr_pgm_rt_id,l_mirror_src_entity_result_id,'DOP') loop
13758: --
13759: l_table_route_id := null ;
13760: open ben_plan_design_program_module.g_table_route('DOP');
13761: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13762: close ben_plan_design_program_module.g_table_route ;
13763: --
13764: l_information5 := ben_plan_design_program_module.get_pgm_name(l_dop_rec.pgm_id,p_effective_date)
13765: || ben_plan_design_program_module.get_exclude_message(l_dop_rec.excld_flag);
13758: --
13759: l_table_route_id := null ;
13760: open ben_plan_design_program_module.g_table_route('DOP');
13761: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13762: close ben_plan_design_program_module.g_table_route ;
13763: --
13764: l_information5 := ben_plan_design_program_module.get_pgm_name(l_dop_rec.pgm_id,p_effective_date)
13765: || ben_plan_design_program_module.get_exclude_message(l_dop_rec.excld_flag);
13766: --'Intersection';
13760: open ben_plan_design_program_module.g_table_route('DOP');
13761: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13762: close ben_plan_design_program_module.g_table_route ;
13763: --
13764: l_information5 := ben_plan_design_program_module.get_pgm_name(l_dop_rec.pgm_id,p_effective_date)
13765: || ben_plan_design_program_module.get_exclude_message(l_dop_rec.excld_flag);
13766: --'Intersection';
13767: --
13768: if p_effective_date between l_dop_rec.effective_start_date
13761: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13762: close ben_plan_design_program_module.g_table_route ;
13763: --
13764: l_information5 := ben_plan_design_program_module.get_pgm_name(l_dop_rec.pgm_id,p_effective_date)
13765: || ben_plan_design_program_module.get_exclude_message(l_dop_rec.excld_flag);
13766: --'Intersection';
13767: --
13768: if p_effective_date between l_dop_rec.effective_start_date
13769: and l_dop_rec.effective_end_date then
13859: --
13860: for l_pap_rec in c_pap(l_parent_rec.prtt_anthr_pl_rt_id,l_mirror_src_entity_result_id,'PAP') loop
13861: --
13862: l_table_route_id := null ;
13863: open ben_plan_design_program_module.g_table_route('PAP');
13864: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13865: close ben_plan_design_program_module.g_table_route ;
13866: --
13867: l_information5 := ben_plan_design_program_module.get_pl_name(l_pap_rec.pl_id,p_effective_date)
13860: for l_pap_rec in c_pap(l_parent_rec.prtt_anthr_pl_rt_id,l_mirror_src_entity_result_id,'PAP') loop
13861: --
13862: l_table_route_id := null ;
13863: open ben_plan_design_program_module.g_table_route('PAP');
13864: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13865: close ben_plan_design_program_module.g_table_route ;
13866: --
13867: l_information5 := ben_plan_design_program_module.get_pl_name(l_pap_rec.pl_id,p_effective_date)
13868: || ben_plan_design_program_module.get_exclude_message(l_pap_rec.excld_flag);
13861: --
13862: l_table_route_id := null ;
13863: open ben_plan_design_program_module.g_table_route('PAP');
13864: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13865: close ben_plan_design_program_module.g_table_route ;
13866: --
13867: l_information5 := ben_plan_design_program_module.get_pl_name(l_pap_rec.pl_id,p_effective_date)
13868: || ben_plan_design_program_module.get_exclude_message(l_pap_rec.excld_flag);
13869: --'Intersection';
13863: open ben_plan_design_program_module.g_table_route('PAP');
13864: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13865: close ben_plan_design_program_module.g_table_route ;
13866: --
13867: l_information5 := ben_plan_design_program_module.get_pl_name(l_pap_rec.pl_id,p_effective_date)
13868: || ben_plan_design_program_module.get_exclude_message(l_pap_rec.excld_flag);
13869: --'Intersection';
13870: --
13871: if p_effective_date between l_pap_rec.effective_start_date
13864: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13865: close ben_plan_design_program_module.g_table_route ;
13866: --
13867: l_information5 := ben_plan_design_program_module.get_pl_name(l_pap_rec.pl_id,p_effective_date)
13868: || ben_plan_design_program_module.get_exclude_message(l_pap_rec.excld_flag);
13869: --'Intersection';
13870: --
13871: if p_effective_date between l_pap_rec.effective_start_date
13872: and l_pap_rec.effective_end_date then
13961: --
13962: for l_eao_rec in c_eao(l_parent_rec.enrld_anthr_oipl_rt_id,l_mirror_src_entity_result_id,'EAO') loop
13963: --
13964: l_table_route_id := null ;
13965: open ben_plan_design_program_module.g_table_route('EAO');
13966: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13967: close ben_plan_design_program_module.g_table_route ;
13968: --
13969: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eao_rec.oipl_id
13962: for l_eao_rec in c_eao(l_parent_rec.enrld_anthr_oipl_rt_id,l_mirror_src_entity_result_id,'EAO') loop
13963: --
13964: l_table_route_id := null ;
13965: open ben_plan_design_program_module.g_table_route('EAO');
13966: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13967: close ben_plan_design_program_module.g_table_route ;
13968: --
13969: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eao_rec.oipl_id
13970: ,p_effective_date)
13963: --
13964: l_table_route_id := null ;
13965: open ben_plan_design_program_module.g_table_route('EAO');
13966: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13967: close ben_plan_design_program_module.g_table_route ;
13968: --
13969: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eao_rec.oipl_id
13970: ,p_effective_date)
13971: || ben_plan_design_program_module.get_exclude_message(l_eao_rec.excld_flag);
13965: open ben_plan_design_program_module.g_table_route('EAO');
13966: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
13967: close ben_plan_design_program_module.g_table_route ;
13968: --
13969: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eao_rec.oipl_id
13970: ,p_effective_date)
13971: || ben_plan_design_program_module.get_exclude_message(l_eao_rec.excld_flag);
13972: --'Intersection';
13973: --
13967: close ben_plan_design_program_module.g_table_route ;
13968: --
13969: l_information5 := ben_plan_design_program_module.get_oipl_name(l_eao_rec.oipl_id
13970: ,p_effective_date)
13971: || ben_plan_design_program_module.get_exclude_message(l_eao_rec.excld_flag);
13972: --'Intersection';
13973: --
13974: if p_effective_date between l_eao_rec.effective_start_date
13975: and l_eao_rec.effective_end_date then
14063: --
14064: for l_enl_rec in c_enl(l_parent_rec.enrld_anthr_pl_rt_id,l_mirror_src_entity_result_id,'ENL') loop
14065: --
14066: l_table_route_id := null ;
14067: open ben_plan_design_program_module.g_table_route('ENL');
14068: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14069: close ben_plan_design_program_module.g_table_route ;
14070: --
14071: l_information5 := ben_plan_design_program_module.get_pl_name(l_enl_rec.pl_id
14064: for l_enl_rec in c_enl(l_parent_rec.enrld_anthr_pl_rt_id,l_mirror_src_entity_result_id,'ENL') loop
14065: --
14066: l_table_route_id := null ;
14067: open ben_plan_design_program_module.g_table_route('ENL');
14068: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14069: close ben_plan_design_program_module.g_table_route ;
14070: --
14071: l_information5 := ben_plan_design_program_module.get_pl_name(l_enl_rec.pl_id
14072: ,p_effective_date)
14065: --
14066: l_table_route_id := null ;
14067: open ben_plan_design_program_module.g_table_route('ENL');
14068: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14069: close ben_plan_design_program_module.g_table_route ;
14070: --
14071: l_information5 := ben_plan_design_program_module.get_pl_name(l_enl_rec.pl_id
14072: ,p_effective_date)
14073: || ben_plan_design_program_module.get_exclude_message(l_enl_rec.excld_flag);
14067: open ben_plan_design_program_module.g_table_route('ENL');
14068: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14069: close ben_plan_design_program_module.g_table_route ;
14070: --
14071: l_information5 := ben_plan_design_program_module.get_pl_name(l_enl_rec.pl_id
14072: ,p_effective_date)
14073: || ben_plan_design_program_module.get_exclude_message(l_enl_rec.excld_flag);
14074: --'Intersection';
14075: --
14069: close ben_plan_design_program_module.g_table_route ;
14070: --
14071: l_information5 := ben_plan_design_program_module.get_pl_name(l_enl_rec.pl_id
14072: ,p_effective_date)
14073: || ben_plan_design_program_module.get_exclude_message(l_enl_rec.excld_flag);
14074: --'Intersection';
14075: --
14076: if p_effective_date between l_enl_rec.effective_start_date
14077: and l_enl_rec.effective_end_date then
14165: --
14166: for l_ear_rec in c_ear(l_parent_rec.enrld_anthr_plip_rt_id,l_mirror_src_entity_result_id,'EAR') loop
14167: --
14168: l_table_route_id := null ;
14169: open ben_plan_design_program_module.g_table_route('EAR');
14170: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14171: close ben_plan_design_program_module.g_table_route ;
14172: --
14173: l_information5 := ben_plan_design_program_module.get_plip_name(l_ear_rec.plip_id,p_effective_date)
14166: for l_ear_rec in c_ear(l_parent_rec.enrld_anthr_plip_rt_id,l_mirror_src_entity_result_id,'EAR') loop
14167: --
14168: l_table_route_id := null ;
14169: open ben_plan_design_program_module.g_table_route('EAR');
14170: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14171: close ben_plan_design_program_module.g_table_route ;
14172: --
14173: l_information5 := ben_plan_design_program_module.get_plip_name(l_ear_rec.plip_id,p_effective_date)
14174: || ben_plan_design_program_module.get_exclude_message(l_ear_rec.excld_flag);
14167: --
14168: l_table_route_id := null ;
14169: open ben_plan_design_program_module.g_table_route('EAR');
14170: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14171: close ben_plan_design_program_module.g_table_route ;
14172: --
14173: l_information5 := ben_plan_design_program_module.get_plip_name(l_ear_rec.plip_id,p_effective_date)
14174: || ben_plan_design_program_module.get_exclude_message(l_ear_rec.excld_flag);
14175: --'Intersection';
14169: open ben_plan_design_program_module.g_table_route('EAR');
14170: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14171: close ben_plan_design_program_module.g_table_route ;
14172: --
14173: l_information5 := ben_plan_design_program_module.get_plip_name(l_ear_rec.plip_id,p_effective_date)
14174: || ben_plan_design_program_module.get_exclude_message(l_ear_rec.excld_flag);
14175: --'Intersection';
14176: --
14177: if p_effective_date between l_ear_rec.effective_start_date
14170: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14171: close ben_plan_design_program_module.g_table_route ;
14172: --
14173: l_information5 := ben_plan_design_program_module.get_plip_name(l_ear_rec.plip_id,p_effective_date)
14174: || ben_plan_design_program_module.get_exclude_message(l_ear_rec.excld_flag);
14175: --'Intersection';
14176: --
14177: if p_effective_date between l_ear_rec.effective_start_date
14178: and l_ear_rec.effective_end_date then
14267: --
14268: for l_ent_rec in c_ent(l_parent_rec.enrld_anthr_ptip_rt_id,l_mirror_src_entity_result_id,'ENT') loop
14269: --
14270: l_table_route_id := null ;
14271: open ben_plan_design_program_module.g_table_route('ENT');
14272: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14273: close ben_plan_design_program_module.g_table_route ;
14274: --
14275: l_information5 := ben_plan_design_program_module.get_ptip_name(l_ent_rec.ptip_id,p_effective_date)
14268: for l_ent_rec in c_ent(l_parent_rec.enrld_anthr_ptip_rt_id,l_mirror_src_entity_result_id,'ENT') loop
14269: --
14270: l_table_route_id := null ;
14271: open ben_plan_design_program_module.g_table_route('ENT');
14272: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14273: close ben_plan_design_program_module.g_table_route ;
14274: --
14275: l_information5 := ben_plan_design_program_module.get_ptip_name(l_ent_rec.ptip_id,p_effective_date)
14276: || ben_plan_design_program_module.get_exclude_message(l_ent_rec.excld_flag);
14269: --
14270: l_table_route_id := null ;
14271: open ben_plan_design_program_module.g_table_route('ENT');
14272: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14273: close ben_plan_design_program_module.g_table_route ;
14274: --
14275: l_information5 := ben_plan_design_program_module.get_ptip_name(l_ent_rec.ptip_id,p_effective_date)
14276: || ben_plan_design_program_module.get_exclude_message(l_ent_rec.excld_flag);
14277: --'Intersection';
14271: open ben_plan_design_program_module.g_table_route('ENT');
14272: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14273: close ben_plan_design_program_module.g_table_route ;
14274: --
14275: l_information5 := ben_plan_design_program_module.get_ptip_name(l_ent_rec.ptip_id,p_effective_date)
14276: || ben_plan_design_program_module.get_exclude_message(l_ent_rec.excld_flag);
14277: --'Intersection';
14278: --
14279: if p_effective_date between l_ent_rec.effective_start_date
14272: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14273: close ben_plan_design_program_module.g_table_route ;
14274: --
14275: l_information5 := ben_plan_design_program_module.get_ptip_name(l_ent_rec.ptip_id,p_effective_date)
14276: || ben_plan_design_program_module.get_exclude_message(l_ent_rec.excld_flag);
14277: --'Intersection';
14278: --
14279: if p_effective_date between l_ent_rec.effective_start_date
14280: and l_ent_rec.effective_end_date then
14369: --
14370: for l_epm_rec in c_epm(l_parent_rec.enrld_anthr_pgm_rt_id,l_mirror_src_entity_result_id,'EPM') loop
14371: --
14372: l_table_route_id := null ;
14373: open ben_plan_design_program_module.g_table_route('EPM');
14374: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14375: close ben_plan_design_program_module.g_table_route ;
14376: --
14377: l_information5 := ben_plan_design_program_module.get_pgm_name(l_epm_rec.pgm_id,p_effective_date)
14370: for l_epm_rec in c_epm(l_parent_rec.enrld_anthr_pgm_rt_id,l_mirror_src_entity_result_id,'EPM') loop
14371: --
14372: l_table_route_id := null ;
14373: open ben_plan_design_program_module.g_table_route('EPM');
14374: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14375: close ben_plan_design_program_module.g_table_route ;
14376: --
14377: l_information5 := ben_plan_design_program_module.get_pgm_name(l_epm_rec.pgm_id,p_effective_date)
14378: || ben_plan_design_program_module.get_exclude_message(l_epm_rec.excld_flag);
14371: --
14372: l_table_route_id := null ;
14373: open ben_plan_design_program_module.g_table_route('EPM');
14374: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14375: close ben_plan_design_program_module.g_table_route ;
14376: --
14377: l_information5 := ben_plan_design_program_module.get_pgm_name(l_epm_rec.pgm_id,p_effective_date)
14378: || ben_plan_design_program_module.get_exclude_message(l_epm_rec.excld_flag);
14379: --'Intersection';
14373: open ben_plan_design_program_module.g_table_route('EPM');
14374: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14375: close ben_plan_design_program_module.g_table_route ;
14376: --
14377: l_information5 := ben_plan_design_program_module.get_pgm_name(l_epm_rec.pgm_id,p_effective_date)
14378: || ben_plan_design_program_module.get_exclude_message(l_epm_rec.excld_flag);
14379: --'Intersection';
14380: --
14381: if p_effective_date between l_epm_rec.effective_start_date
14374: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14375: close ben_plan_design_program_module.g_table_route ;
14376: --
14377: l_information5 := ben_plan_design_program_module.get_pgm_name(l_epm_rec.pgm_id,p_effective_date)
14378: || ben_plan_design_program_module.get_exclude_message(l_epm_rec.excld_flag);
14379: --'Intersection';
14380: --
14381: if p_effective_date between l_epm_rec.effective_start_date
14382: and l_epm_rec.effective_end_date then
14471: --
14472: for l_noc_rec in c_noc(l_parent_rec.no_othr_cvg_rt_id,l_mirror_src_entity_result_id,'NOC') loop
14473: --
14474: l_table_route_id := null ;
14475: open ben_plan_design_program_module.g_table_route('NOC');
14476: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14477: close ben_plan_design_program_module.g_table_route ;
14478: --
14479: l_information5 := hr_general.decode_lookup('YES_NO',l_noc_rec.coord_ben_no_cvg_flag);
14472: for l_noc_rec in c_noc(l_parent_rec.no_othr_cvg_rt_id,l_mirror_src_entity_result_id,'NOC') loop
14473: --
14474: l_table_route_id := null ;
14475: open ben_plan_design_program_module.g_table_route('NOC');
14476: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14477: close ben_plan_design_program_module.g_table_route ;
14478: --
14479: l_information5 := hr_general.decode_lookup('YES_NO',l_noc_rec.coord_ben_no_cvg_flag);
14480: --'Intersection';
14473: --
14474: l_table_route_id := null ;
14475: open ben_plan_design_program_module.g_table_route('NOC');
14476: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14477: close ben_plan_design_program_module.g_table_route ;
14478: --
14479: l_information5 := hr_general.decode_lookup('YES_NO',l_noc_rec.coord_ben_no_cvg_flag);
14480: --'Intersection';
14481: --
14570: --
14571: for l_omr_rec in c_omr(l_parent_rec.optd_mdcr_rt_id,l_mirror_src_entity_result_id,'OMR') loop
14572: --
14573: l_table_route_id := null ;
14574: open ben_plan_design_program_module.g_table_route('OMR');
14575: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14576: close ben_plan_design_program_module.g_table_route ;
14577: --
14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)
14571: for l_omr_rec in c_omr(l_parent_rec.optd_mdcr_rt_id,l_mirror_src_entity_result_id,'OMR') loop
14572: --
14573: l_table_route_id := null ;
14574: open ben_plan_design_program_module.g_table_route('OMR');
14575: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14576: close ben_plan_design_program_module.g_table_route ;
14577: --
14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)
14579: || ben_plan_design_program_module.get_exclude_message(l_omr_rec.exlcd_flag);
14572: --
14573: l_table_route_id := null ;
14574: open ben_plan_design_program_module.g_table_route('OMR');
14575: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14576: close ben_plan_design_program_module.g_table_route ;
14577: --
14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)
14579: || ben_plan_design_program_module.get_exclude_message(l_omr_rec.exlcd_flag);
14580: --
14575: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14576: close ben_plan_design_program_module.g_table_route ;
14577: --
14578: l_information5 := hr_general.decode_lookup('YES_NO',l_omr_rec.optd_mdcr_flag)
14579: || ben_plan_design_program_module.get_exclude_message(l_omr_rec.exlcd_flag);
14580: --
14581: if p_effective_date between l_omr_rec.effective_start_date
14582: and l_omr_rec.effective_end_date then
14583: --
14670: --
14671: for l_dot_rec in c_dot(l_parent_rec.dpnt_othr_ptip_rt_id,l_mirror_src_entity_result_id,'DOT') loop
14672: --
14673: l_table_route_id := null ;
14674: open ben_plan_design_program_module.g_table_route('DOT');
14675: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14676: close ben_plan_design_program_module.g_table_route ;
14677: --
14678: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dot_rec.ptip_id,p_effective_date)
14671: for l_dot_rec in c_dot(l_parent_rec.dpnt_othr_ptip_rt_id,l_mirror_src_entity_result_id,'DOT') loop
14672: --
14673: l_table_route_id := null ;
14674: open ben_plan_design_program_module.g_table_route('DOT');
14675: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14676: close ben_plan_design_program_module.g_table_route ;
14677: --
14678: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dot_rec.ptip_id,p_effective_date)
14679: || ben_plan_design_program_module.get_exclude_message(l_dot_rec.excld_flag);
14672: --
14673: l_table_route_id := null ;
14674: open ben_plan_design_program_module.g_table_route('DOT');
14675: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14676: close ben_plan_design_program_module.g_table_route ;
14677: --
14678: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dot_rec.ptip_id,p_effective_date)
14679: || ben_plan_design_program_module.get_exclude_message(l_dot_rec.excld_flag);
14680: --
14674: open ben_plan_design_program_module.g_table_route('DOT');
14675: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14676: close ben_plan_design_program_module.g_table_route ;
14677: --
14678: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dot_rec.ptip_id,p_effective_date)
14679: || ben_plan_design_program_module.get_exclude_message(l_dot_rec.excld_flag);
14680: --
14681: if p_effective_date between l_dot_rec.effective_start_date
14682: and l_dot_rec.effective_end_date then
14675: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14676: close ben_plan_design_program_module.g_table_route ;
14677: --
14678: l_information5 := ben_plan_design_program_module.get_ptip_name(l_dot_rec.ptip_id,p_effective_date)
14679: || ben_plan_design_program_module.get_exclude_message(l_dot_rec.excld_flag);
14680: --
14681: if p_effective_date between l_dot_rec.effective_start_date
14682: and l_dot_rec.effective_end_date then
14683: --
14770: --
14771: for l_prr_rec in c_prr(l_parent_rec.perf_rtng_rt_id,l_mirror_src_entity_result_id,'PRR') loop
14772: --
14773: l_table_route_id := null ;
14774: open ben_plan_design_program_module.g_table_route('PRR');
14775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14771: for l_prr_rec in c_prr(l_parent_rec.perf_rtng_rt_id,l_mirror_src_entity_result_id,'PRR') loop
14772: --
14773: l_table_route_id := null ;
14774: open ben_plan_design_program_module.g_table_route('PRR');
14775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)
14772: --
14773: l_table_route_id := null ;
14774: open ben_plan_design_program_module.g_table_route('PRR');
14775: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)
14780: || ben_plan_design_program_module.get_exclude_message(l_prr_rec.excld_flag);
14776: close ben_plan_design_program_module.g_table_route ;
14777: --
14778: l_information5 := hr_general.decode_lookup('EMP_INTERVIEW_TYPE',l_prr_rec.event_type)
14779: ||' - '||hr_general.decode_lookup('PERFORMANCE_RATING',l_prr_rec.perf_rtng_cd)
14780: || ben_plan_design_program_module.get_exclude_message(l_prr_rec.excld_flag);
14781: --'Intersection';
14782: --
14783: if p_effective_date between l_prr_rec.effective_start_date
14784: and l_prr_rec.effective_end_date then
14874: --
14875: for l_qig_rec in c_qig(l_parent_rec.qua_in_gr_rt_id,l_mirror_src_entity_result_id,'QIG') loop
14876: --
14877: l_table_route_id := null ;
14878: open ben_plan_design_program_module.g_table_route('QIG');
14879: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14880: close ben_plan_design_program_module.g_table_route ;
14881: --
14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)
14875: for l_qig_rec in c_qig(l_parent_rec.qua_in_gr_rt_id,l_mirror_src_entity_result_id,'QIG') loop
14876: --
14877: l_table_route_id := null ;
14878: open ben_plan_design_program_module.g_table_route('QIG');
14879: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14880: close ben_plan_design_program_module.g_table_route ;
14881: --
14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)
14883: || ben_plan_design_program_module.get_exclude_message(l_qig_rec.excld_flag);
14876: --
14877: l_table_route_id := null ;
14878: open ben_plan_design_program_module.g_table_route('QIG');
14879: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14880: close ben_plan_design_program_module.g_table_route ;
14881: --
14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)
14883: || ben_plan_design_program_module.get_exclude_message(l_qig_rec.excld_flag);
14884: -- 'Intersection';
14879: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14880: close ben_plan_design_program_module.g_table_route ;
14881: --
14882: l_information5 := hr_general.decode_lookup('BEN_CWB_QUAR_IN_GRD',l_qig_rec.quar_in_grade_cd)
14883: || ben_plan_design_program_module.get_exclude_message(l_qig_rec.excld_flag);
14884: -- 'Intersection';
14885: --
14886: if p_effective_date between l_qig_rec.effective_start_date
14887: and l_qig_rec.effective_end_date then
14976: --
14977: for l_opr_rec in c_opr(l_parent_rec.othr_ptip_rt_id,l_mirror_src_entity_result_id,'OPR') loop
14978: --
14979: l_table_route_id := null ;
14980: open ben_plan_design_program_module.g_table_route('OPR');
14981: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14982: close ben_plan_design_program_module.g_table_route ;
14983: --
14984: l_information5 := ben_plan_design_program_module.get_ptip_name(l_opr_rec.ptip_id,p_effective_date)
14977: for l_opr_rec in c_opr(l_parent_rec.othr_ptip_rt_id,l_mirror_src_entity_result_id,'OPR') loop
14978: --
14979: l_table_route_id := null ;
14980: open ben_plan_design_program_module.g_table_route('OPR');
14981: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14982: close ben_plan_design_program_module.g_table_route ;
14983: --
14984: l_information5 := ben_plan_design_program_module.get_ptip_name(l_opr_rec.ptip_id,p_effective_date)
14985: || ben_plan_design_program_module.get_exclude_message(l_opr_rec.excld_flag);
14978: --
14979: l_table_route_id := null ;
14980: open ben_plan_design_program_module.g_table_route('OPR');
14981: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14982: close ben_plan_design_program_module.g_table_route ;
14983: --
14984: l_information5 := ben_plan_design_program_module.get_ptip_name(l_opr_rec.ptip_id,p_effective_date)
14985: || ben_plan_design_program_module.get_exclude_message(l_opr_rec.excld_flag);
14986: --'Intersection';
14980: open ben_plan_design_program_module.g_table_route('OPR');
14981: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14982: close ben_plan_design_program_module.g_table_route ;
14983: --
14984: l_information5 := ben_plan_design_program_module.get_ptip_name(l_opr_rec.ptip_id,p_effective_date)
14985: || ben_plan_design_program_module.get_exclude_message(l_opr_rec.excld_flag);
14986: --'Intersection';
14987: --
14988: if p_effective_date between l_opr_rec.effective_start_date
14981: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
14982: close ben_plan_design_program_module.g_table_route ;
14983: --
14984: l_information5 := ben_plan_design_program_module.get_ptip_name(l_opr_rec.ptip_id,p_effective_date)
14985: || ben_plan_design_program_module.get_exclude_message(l_opr_rec.excld_flag);
14986: --'Intersection';
14987: --
14988: if p_effective_date between l_opr_rec.effective_start_date
14989: and l_opr_rec.effective_end_date then
15249: for l_bpp_rec in c_bpp(l_parent_rec.bnft_prvdr_pool_id,l_mirror_src_entity_result_id,'BPP') loop
15250: --
15251:
15252: l_table_route_id := null ;
15253: open ben_plan_design_program_module.g_table_route('BPP');
15254: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15255: close ben_plan_design_program_module.g_table_route ;
15256: --
15257: l_information5 := l_bpp_rec.name; --'Intersection';
15250: --
15251:
15252: l_table_route_id := null ;
15253: open ben_plan_design_program_module.g_table_route('BPP');
15254: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15255: close ben_plan_design_program_module.g_table_route ;
15256: --
15257: l_information5 := l_bpp_rec.name; --'Intersection';
15258: --
15251:
15252: l_table_route_id := null ;
15253: open ben_plan_design_program_module.g_table_route('BPP');
15254: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15255: close ben_plan_design_program_module.g_table_route ;
15256: --
15257: l_information5 := l_bpp_rec.name; --'Intersection';
15258: --
15259: if p_effective_date between l_bpp_rec.effective_start_date
15390: ---------------------------------------------------------------
15391: --
15392: if l_bpp_rec.dflt_excs_trtmt_rl is not null then
15393: --
15394: ben_plan_design_program_module.create_formula_result
15395: (
15396: p_validate => 0
15397: ,p_copy_entity_result_id => l_copy_entity_result_id
15398: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15412: ---------------------------------------------------------------
15413: --
15414: if l_bpp_rec.pct_rndg_rl is not null then
15415: --
15416: ben_plan_design_program_module.create_formula_result
15417: (
15418: p_validate => 0
15419: ,p_copy_entity_result_id => l_copy_entity_result_id
15420: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15434: ---------------------------------------------------------------
15435: --
15436: if l_bpp_rec.val_rndg_rl is not null then
15437: --
15438: ben_plan_design_program_module.create_formula_result
15439: (
15440: p_validate => 0
15441: ,p_copy_entity_result_id => l_copy_entity_result_id
15442: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15465: --
15466: for l_abp_rec in c_abp(l_parent_rec.aplcn_to_bnft_pool_id,l_mirror_src_entity_result_id,'ABP') loop
15467: --
15468: l_table_route_id := null ;
15469: open ben_plan_design_program_module.g_table_route('ABP');
15470: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15471: close ben_plan_design_program_module.g_table_route ;
15472: --
15473: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_abp_rec.acty_base_rt_id
15466: for l_abp_rec in c_abp(l_parent_rec.aplcn_to_bnft_pool_id,l_mirror_src_entity_result_id,'ABP') loop
15467: --
15468: l_table_route_id := null ;
15469: open ben_plan_design_program_module.g_table_route('ABP');
15470: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15471: close ben_plan_design_program_module.g_table_route ;
15472: --
15473: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_abp_rec.acty_base_rt_id
15474: ,p_effective_date); --'Intersection';
15467: --
15468: l_table_route_id := null ;
15469: open ben_plan_design_program_module.g_table_route('ABP');
15470: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15471: close ben_plan_design_program_module.g_table_route ;
15472: --
15473: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_abp_rec.acty_base_rt_id
15474: ,p_effective_date); --'Intersection';
15475: --
15469: open ben_plan_design_program_module.g_table_route('ABP');
15470: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15471: close ben_plan_design_program_module.g_table_route ;
15472: --
15473: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_abp_rec.acty_base_rt_id
15474: ,p_effective_date); --'Intersection';
15475: --
15476: if p_effective_date between l_abp_rec.effective_start_date
15477: and l_abp_rec.effective_end_date then
15562: --
15563: for l_bpr_rec in c_bpr(l_parent_rec.bnft_pool_rlovr_rqmt_id,l_mirror_src_entity_result_id,'BPR1') loop
15564: --
15565: l_table_route_id := null ;
15566: open ben_plan_design_program_module.g_table_route('BPR1');
15567: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15568: close ben_plan_design_program_module.g_table_route ;
15569: --
15570: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_bpr_rec.acty_base_rt_id
15563: for l_bpr_rec in c_bpr(l_parent_rec.bnft_pool_rlovr_rqmt_id,l_mirror_src_entity_result_id,'BPR1') loop
15564: --
15565: l_table_route_id := null ;
15566: open ben_plan_design_program_module.g_table_route('BPR1');
15567: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15568: close ben_plan_design_program_module.g_table_route ;
15569: --
15570: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_bpr_rec.acty_base_rt_id
15571: ,p_effective_date); --'Intersection';
15564: --
15565: l_table_route_id := null ;
15566: open ben_plan_design_program_module.g_table_route('BPR1');
15567: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15568: close ben_plan_design_program_module.g_table_route ;
15569: --
15570: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_bpr_rec.acty_base_rt_id
15571: ,p_effective_date); --'Intersection';
15572: --
15566: open ben_plan_design_program_module.g_table_route('BPR1');
15567: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15568: close ben_plan_design_program_module.g_table_route ;
15569: --
15570: l_information5 := ben_plan_design_program_module.get_acty_base_rt_name(l_bpr_rec.acty_base_rt_id
15571: ,p_effective_date); --'Intersection';
15572: --
15573: if p_effective_date between l_bpr_rec.effective_start_date
15574: and l_bpr_rec.effective_end_date then
15669: ---------------------------------------------------------------
15670: --
15671: if l_bpr_rec.pct_rndg_rl is not null then
15672: --
15673: ben_plan_design_program_module.create_formula_result
15674: (
15675: p_validate => 0
15676: ,p_copy_entity_result_id => l_copy_entity_result_id
15677: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15691: ---------------------------------------------------------------
15692: --
15693: if l_bpr_rec.prtt_elig_rlovr_rl is not null then
15694: --
15695: ben_plan_design_program_module.create_formula_result
15696: (
15697: p_validate => 0
15698: ,p_copy_entity_result_id => l_copy_entity_result_id
15699: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15713: ---------------------------------------------------------------
15714: --
15715: if l_bpr_rec.rlovr_val_rl is not null then
15716: --
15717: ben_plan_design_program_module.create_formula_result
15718: (
15719: p_validate => 0
15720: ,p_copy_entity_result_id => l_copy_entity_result_id
15721: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15734: ---------------------------------------------------------------
15735: --
15736: if l_bpr_rec.val_rndg_rl is not null then
15737: --
15738: ben_plan_design_program_module.create_formula_result
15739: (
15740: p_validate => 0
15741: ,p_copy_entity_result_id => l_copy_entity_result_id
15742: ,p_copy_entity_txn_id => p_copy_entity_txn_id
15896: l_dummy varchar2(1);
15897:
15898: begin
15899:
15900: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
15901: open c_object_exists(p_svc_area_id,'SVA');
15902: fetch c_object_exists into l_dummy;
15903: if c_object_exists%found then
15904: close c_object_exists;
15918: --
15919: for l_sva_rec in c_sva(l_svc_area_id,l_mirror_src_entity_result_id,'SVA') loop
15920: --
15921: l_table_route_id := null ;
15922: open ben_plan_design_program_module.g_table_route('SVA');
15923: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15924: close ben_plan_design_program_module.g_table_route ;
15925: --
15926: l_information5 := l_sva_rec.name; --'Intersection';
15919: for l_sva_rec in c_sva(l_svc_area_id,l_mirror_src_entity_result_id,'SVA') loop
15920: --
15921: l_table_route_id := null ;
15922: open ben_plan_design_program_module.g_table_route('SVA');
15923: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15924: close ben_plan_design_program_module.g_table_route ;
15925: --
15926: l_information5 := l_sva_rec.name; --'Intersection';
15927: --
15920: --
15921: l_table_route_id := null ;
15922: open ben_plan_design_program_module.g_table_route('SVA');
15923: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
15924: close ben_plan_design_program_module.g_table_route ;
15925: --
15926: l_information5 := l_sva_rec.name; --'Intersection';
15927: --
15928: if p_effective_date between l_sva_rec.effective_start_date
16004: -- START OF BEN_SVC_AREA_PSTL_ZIP_RNG_F ----------------------
16005: ---------------------------------------------------------------
16006: -- Bug - 4241267 - moved code outside of loop
16007: l_table_route_id := null ;
16008: open ben_plan_design_program_module.g_table_route('SAZ');
16009: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16010: close ben_plan_design_program_module.g_table_route ;
16011: --
16012:
16005: ---------------------------------------------------------------
16006: -- Bug - 4241267 - moved code outside of loop
16007: l_table_route_id := null ;
16008: open ben_plan_design_program_module.g_table_route('SAZ');
16009: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16010: close ben_plan_design_program_module.g_table_route ;
16011: --
16012:
16013: for l_parent_rec in c_saz_from_parent(l_SVC_AREA_ID) loop
16006: -- Bug - 4241267 - moved code outside of loop
16007: l_table_route_id := null ;
16008: open ben_plan_design_program_module.g_table_route('SAZ');
16009: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16010: close ben_plan_design_program_module.g_table_route ;
16011: --
16012:
16013: for l_parent_rec in c_saz_from_parent(l_SVC_AREA_ID) loop
16014: --
16018: l_svc_area_pstl_zip_rng_id := l_parent_rec.svc_area_pstl_zip_rng_id ;
16019: --
16020: for l_saz_rec in c_saz(l_parent_rec.svc_area_pstl_zip_rng_id,l_mirror_src_entity_result_id,'SAZ') loop
16021: --
16022: l_information5 := ben_plan_design_program_module.get_pstl_zip_rng_name(l_saz_rec.pstl_zip_rng_id
16023: ,p_effective_date); --'Intersection';
16024: --
16025: if p_effective_date between l_saz_rec.effective_start_date
16026: and l_saz_rec.effective_end_date then
16203: l_dummy varchar2(1);
16204:
16205: begin
16206:
16207: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
16208: open c_object_exists(p_pstl_zip_rng_id,'RZR');
16209: fetch c_object_exists into l_dummy;
16210: if c_object_exists%found then
16211: close c_object_exists;
16219: -- START OF BEN_PSTL_ZIP_RNG_F ----------------------
16220: ---------------------------------------------------------------
16221: -- bug 4241267 - moved code outside of loop
16222: l_table_route_id := null ;
16223: open ben_plan_design_program_module.g_table_route('RZR');
16224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16225: close ben_plan_design_program_module.g_table_route ;
16226: --
16227: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
16220: ---------------------------------------------------------------
16221: -- bug 4241267 - moved code outside of loop
16222: l_table_route_id := null ;
16223: open ben_plan_design_program_module.g_table_route('RZR');
16224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16225: close ben_plan_design_program_module.g_table_route ;
16226: --
16227: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
16228: --
16221: -- bug 4241267 - moved code outside of loop
16222: l_table_route_id := null ;
16223: open ben_plan_design_program_module.g_table_route('RZR');
16224: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16225: close ben_plan_design_program_module.g_table_route ;
16226: --
16227: l_mirror_src_entity_result_id := p_copy_entity_result_id ;
16228: --
16229: l_pstl_zip_rng_id := p_pstl_zip_rng_id ;
16396: l_dummy varchar2(1);
16397:
16398: begin
16399:
16400: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
16401: open c_object_exists(p_bnfts_bal_id,'BNB');
16402: fetch c_object_exists into l_dummy;
16403: if c_object_exists%found then
16404: close c_object_exists;
16418: --
16419: for l_bnb_rec in c_bnb(p_bnfts_bal_id,l_mirror_src_entity_result_id,'BNB') loop
16420: --
16421: l_table_route_id := null ;
16422: open ben_plan_design_program_module.g_table_route('BNB');
16423: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16424: close ben_plan_design_program_module.g_table_route ;
16425: --
16426: l_information5 := l_bnb_rec.name; --'Intersection';
16419: for l_bnb_rec in c_bnb(p_bnfts_bal_id,l_mirror_src_entity_result_id,'BNB') loop
16420: --
16421: l_table_route_id := null ;
16422: open ben_plan_design_program_module.g_table_route('BNB');
16423: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16424: close ben_plan_design_program_module.g_table_route ;
16425: --
16426: l_information5 := l_bnb_rec.name; --'Intersection';
16427: --
16420: --
16421: l_table_route_id := null ;
16422: open ben_plan_design_program_module.g_table_route('BNB');
16423: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16424: close ben_plan_design_program_module.g_table_route ;
16425: --
16426: l_information5 := l_bnb_rec.name; --'Intersection';
16427: --
16428: if p_effective_date between l_bnb_rec.effective_start_date
16587: and information1 = c_pk_id;
16588:
16589: l_dummy varchar2(1);
16590: begin
16591: if ben_plan_design_program_module.g_pdw_allow_dup_rslt = ben_plan_design_program_module.g_pdw_no_dup_rslt then
16592: open c_object_exists(p_benfts_grp_id,'BNG');
16593: fetch c_object_exists into l_dummy;
16594: if c_object_exists%found then
16595: close c_object_exists;
16609: --
16610: for l_bng_rec in c_bng(p_benfts_grp_id,l_mirror_src_entity_result_id,'BNG') loop
16611: --
16612: l_table_route_id := null ;
16613: open ben_plan_design_program_module.g_table_route('BNG');
16614: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16615: close ben_plan_design_program_module.g_table_route ;
16616: --
16617: l_information5 := l_bng_rec.name; --'Intersection';
16610: for l_bng_rec in c_bng(p_benfts_grp_id,l_mirror_src_entity_result_id,'BNG') loop
16611: --
16612: l_table_route_id := null ;
16613: open ben_plan_design_program_module.g_table_route('BNG');
16614: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16615: close ben_plan_design_program_module.g_table_route ;
16616: --
16617: l_information5 := l_bng_rec.name; --'Intersection';
16618: --
16611: --
16612: l_table_route_id := null ;
16613: open ben_plan_design_program_module.g_table_route('BNG');
16614: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16615: close ben_plan_design_program_module.g_table_route ;
16616: --
16617: l_information5 := l_bng_rec.name; --'Intersection';
16618: --
16619: l_result_type_cd := 'DISPLAY';
16778: --
16779: for l_apc_rec in c_apc(l_parent_rec.acrs_ptip_cvg_id,l_mirror_src_entity_result_id,'ACP') loop
16780: --
16781: l_table_route_id := null ;
16782: open ben_plan_design_program_module.g_table_route('ACP');
16783: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16784: close ben_plan_design_program_module.g_table_route ;
16785: --
16786: l_information5 := l_apc_rec.name; --'Intersection';
16779: for l_apc_rec in c_apc(l_parent_rec.acrs_ptip_cvg_id,l_mirror_src_entity_result_id,'ACP') loop
16780: --
16781: l_table_route_id := null ;
16782: open ben_plan_design_program_module.g_table_route('ACP');
16783: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16784: close ben_plan_design_program_module.g_table_route ;
16785: --
16786: l_information5 := l_apc_rec.name; --'Intersection';
16787: --
16780: --
16781: l_table_route_id := null ;
16782: open ben_plan_design_program_module.g_table_route('ACP');
16783: fetch ben_plan_design_program_module.g_table_route into l_table_route_id ;
16784: close ben_plan_design_program_module.g_table_route ;
16785: --
16786: l_information5 := l_apc_rec.name; --'Intersection';
16787: --
16788: l_result_type_cd := 'DISPLAY';