[Home] [Help]
508: --
509: end if;
510: --
511: if c_earthquake_max is null then
512: c_earthquake_max := to_number(hruserdt.get_table_value(
513: g_business_group_id,
514: c_yea_calc_max_udt,
515: c_max_udtcol,
516: c_earthquake_udtrow,
538: l_effective_date := g_effective_date;
539: --
540: end if;
541: --
542: l_nonlife_max := to_number(hruserdt.get_table_value(
543: g_business_group_id,
544: c_yea_calc_max_udt,
545: c_max_udtcol,
546: c_nonlife_udtrow,
556: l_effective_date := c_st_upd_date_2007 - 1;
557: --
558: end if;
559: --
560: l_nonlife_max_2007 := to_number(hruserdt.get_table_value(
561: g_business_group_id,
562: c_yea_calc_max_udt,
563: c_max_udtcol,
564: c_nonlife_udtrow,
588: l_effective_date := g_effective_date;
589: --
590: if c_emp_income_max is null then
591: --
592: c_emp_income_max := to_number(hruserdt.get_table_value(
593: g_business_group_id,
594: c_yea_calc_max_udt,
595: c_max_udtcol,
596: c_sp_emp_income_udtrow,
603: l_effective_date := g_effective_date;
604: --
605: if c_inc_spouse_dct_max is null then
606: --
607: c_inc_spouse_dct_max := to_number(hruserdt.get_table_value(
608: g_business_group_id,
609: c_yea_calc_max_udt,
610: c_max_udtcol,
611: c_sp_dctable_sp_income_udtrow,
617: --
618: l_effective_date := g_effective_date;
619: --
620: if c_spouse_income_max is null then
621: c_spouse_income_max := to_number(hruserdt.get_table_value(
622: g_business_group_id,
623: c_yea_calc_max_udt,
624: c_max_udtcol,
625: c_sp_spouse_income_udtrow,
1535: end if;
1536: --
1537: -- udt satisfy validation of max value
1538: o_life_gen := round(i_life_gen
1539: * to_number(hruserdt.get_table_value(
1540: p_business_group_id,
1541: c_life_gen_calc_udt,
1542: c_rate_udtcol,
1543: to_char(i_life_gen),
1541: c_life_gen_calc_udt,
1542: c_rate_udtcol,
1543: to_char(i_life_gen),
1544: p_effective_date))
1545: + to_number(hruserdt.get_table_value(
1546: p_business_group_id,
1547: c_life_gen_calc_udt,
1548: c_add_adj_udtcol,
1549: to_char(i_life_gen),
1566: end if;
1567: --
1568: -- udt satisfy validation of max value
1569: o_life_pens := round(i_life_pens
1570: * to_number(hruserdt.get_table_value(
1571: p_business_group_id,
1572: c_life_pens_calc_udt,
1573: c_rate_udtcol,
1574: to_char(i_life_pens),
1572: c_life_pens_calc_udt,
1573: c_rate_udtcol,
1574: to_char(i_life_pens),
1575: p_effective_date))
1576: + to_number(hruserdt.get_table_value(
1577: p_business_group_id,
1578: c_life_pens_calc_udt,
1579: c_add_adj_udtcol,
1580: to_char(i_life_pens),
1658: end if;
1659: --
1660: -- udt satisfy validation of max value
1661: o_nonlife_long := round(i_nonlife_long
1662: * to_number(hruserdt.get_table_value(
1663: p_business_group_id,
1664: c_nonlife_long_calc_udt,
1665: c_rate_udtcol,
1666: to_char(i_nonlife_long),
1664: c_nonlife_long_calc_udt,
1665: c_rate_udtcol,
1666: to_char(i_nonlife_long),
1667: p_effective_date))
1668: + to_number(hruserdt.get_table_value(
1669: p_business_group_id,
1670: c_nonlife_long_calc_udt,
1671: c_add_adj_udtcol,
1672: to_char(i_nonlife_long),
1689: end if;
1690: --
1691: -- udt satisfy validation of max value
1692: o_nonlife_short := round(i_nonlife_short
1693: * to_number(hruserdt.get_table_value(
1694: p_business_group_id,
1695: c_nonlife_short_calc_udt,
1696: c_rate_udtcol,
1697: to_char(i_nonlife_short),
1695: c_nonlife_short_calc_udt,
1696: c_rate_udtcol,
1697: to_char(i_nonlife_short),
1698: p_effective_date))
1699: + to_number(hruserdt.get_table_value(
1700: p_business_group_id,
1701: c_nonlife_short_calc_udt,
1702: c_add_adj_udtcol,
1703: to_char(i_nonlife_short),
1715: or g_effective_date is null
1716: or c_nonlife_max is null then
1717: --
1718: -- need always reset cache has problem in case date is switched between 2006 and 2007.
1719: c_nonlife_max := to_number(hruserdt.get_table_value(
1720: p_business_group_id,
1721: c_yea_calc_max_udt,
1722: c_max_udtcol,
1723: c_nonlife_udtrow,
1755: end if;
1756: --
1757: o_earthquake := round(i_earthquake);
1758: if c_earthquake_max is null then
1759: c_earthquake_max := to_number(hruserdt.get_table_value(
1760: p_business_group_id,
1761: c_yea_calc_max_udt,
1762: c_max_udtcol,
1763: c_earthquake_udtrow,
1787: end if;
1788: --
1789: -- udt satisfy validation of max value
1790: o_nonlife_long := round(i_nonlife_long
1791: * to_number(hruserdt.get_table_value(
1792: p_business_group_id,
1793: c_nonlife_long_calc_udt,
1794: c_rate_udtcol,
1795: to_char(i_nonlife_long),
1793: c_nonlife_long_calc_udt,
1794: c_rate_udtcol,
1795: to_char(i_nonlife_long),
1796: p_effective_date))
1797: + to_number(hruserdt.get_table_value(
1798: p_business_group_id,
1799: c_nonlife_long_calc_udt,
1800: c_add_adj_udtcol,
1801: to_char(i_nonlife_long),
1817: or g_effective_date is null
1818: or c_nonlife_max is null then
1819: --
1820: -- need always reset cache has problem in case date is switched between 2006 and 2007.
1821: c_nonlife_max := to_number(hruserdt.get_table_value(
1822: p_business_group_id,
1823: c_yea_calc_max_udt,
1824: c_max_udtcol,
1825: c_nonlife_udtrow,
2113: end if;
2114: --
2115: if c_emp_income_max is null then
2116: --
2117: c_emp_income_max := to_number(hruserdt.get_table_value(
2118: p_business_group_id,
2119: c_yea_calc_max_udt,
2120: c_max_udtcol,
2121: c_sp_emp_income_udtrow,
2139: end if;
2140: --
2141: if c_inc_spouse_dct_max is null then
2142: --
2143: c_inc_spouse_dct_max := to_number(hruserdt.get_table_value(
2144: p_business_group_id,
2145: c_yea_calc_max_udt,
2146: c_max_udtcol,
2147: c_sp_dctable_sp_income_udtrow,
2163: end if;
2164: --
2165: if c_spouse_income_max is null then
2166: --
2167: c_spouse_income_max := to_number(hruserdt.get_table_value(
2168: p_business_group_id,
2169: c_yea_calc_max_udt,
2170: c_max_udtcol,
2171: c_sp_spouse_income_udtrow,
2180: end if;
2181: --
2182: if i_spouse_income < c_spouse_income_max then
2183: --
2184: o_spouse_dct := round(to_number(hruserdt.get_table_value(
2185: p_business_group_id,
2186: c_spouse_calc_udt,
2187: c_dct_udtcol,
2188: to_char(i_spouse_income),