APPS.PAY_JP_ISDF_SS_PKG dependencies on PAY_JP_REPORT_PKG

Line 517: c_earthquake_max := to_number(pay_jp_report_pkg.get_udt_value(

513: --
514: end if;
515: --
516: if c_earthquake_max is null then
517: c_earthquake_max := to_number(pay_jp_report_pkg.get_udt_value(
518: g_business_group_id,
519: c_yea_calc_max_udt,
520: c_max_udtcol,
521: c_earthquake_udtrow,

Line 547: l_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(

543: l_effective_date := g_effective_date;
544: --
545: end if;
546: --
547: l_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(
548: g_business_group_id,
549: c_yea_calc_max_udt,
550: c_max_udtcol,
551: c_nonlife_udtrow,

Line 565: l_nonlife_max_2007 := to_number(pay_jp_report_pkg.get_udt_value(

561: l_effective_date := c_st_upd_date_2007 - 1;
562: --
563: end if;
564: --
565: l_nonlife_max_2007 := to_number(pay_jp_report_pkg.get_udt_value(
566: g_business_group_id,
567: c_yea_calc_max_udt,
568: c_max_udtcol,
569: c_nonlife_udtrow,

Line 597: c_emp_income_max := to_number(pay_jp_report_pkg.get_udt_value(

593: l_effective_date := g_effective_date;
594: --
595: if c_emp_income_max is null then
596: --
597: c_emp_income_max := to_number(pay_jp_report_pkg.get_udt_value(
598: g_business_group_id,
599: c_yea_calc_max_udt,
600: c_max_udtcol,
601: c_sp_emp_income_udtrow,

Line 612: c_inc_spouse_dct_max := to_number(pay_jp_report_pkg.get_udt_value(

608: l_effective_date := g_effective_date;
609: --
610: if c_inc_spouse_dct_max is null then
611: --
612: c_inc_spouse_dct_max := to_number(pay_jp_report_pkg.get_udt_value(
613: g_business_group_id,
614: c_yea_calc_max_udt,
615: c_max_udtcol,
616: c_sp_dctable_sp_income_udtrow,

Line 626: c_spouse_income_max := to_number(pay_jp_report_pkg.get_udt_value(

622: --
623: l_effective_date := g_effective_date;
624: --
625: if c_spouse_income_max is null then
626: c_spouse_income_max := to_number(pay_jp_report_pkg.get_udt_value(
627: g_business_group_id,
628: c_yea_calc_max_udt,
629: c_max_udtcol,
630: c_sp_spouse_income_udtrow,

Line 1979: * to_number(pay_jp_report_pkg.get_udt_value(

1975: end if;
1976: --
1977: -- udt satisfy validation of max value
1978: o_life_gen := round(i_life_gen
1979: * to_number(pay_jp_report_pkg.get_udt_value(
1980: p_business_group_id,
1981: c_life_gen_calc_udt,
1982: c_rate_udtcol,
1983: to_char(i_life_gen),

Line 1985: + to_number(pay_jp_report_pkg.get_udt_value(

1981: c_life_gen_calc_udt,
1982: c_rate_udtcol,
1983: to_char(i_life_gen),
1984: p_effective_date))
1985: + to_number(pay_jp_report_pkg.get_udt_value(
1986: p_business_group_id,
1987: c_life_gen_calc_udt,
1988: c_add_adj_udtcol,
1989: to_char(i_life_gen),

Line 2006: * to_number(pay_jp_report_pkg.get_udt_value(

2002: end if;
2003: --
2004: -- udt satisfy validation of max value
2005: o_life_gen_new := round(i_life_gen_new
2006: * to_number(pay_jp_report_pkg.get_udt_value(
2007: p_business_group_id,
2008: c_life_gen_new_calc_udt,
2009: c_rate_udtcol,
2010: to_char(i_life_gen_new),

Line 2012: + to_number(pay_jp_report_pkg.get_udt_value(

2008: c_life_gen_new_calc_udt,
2009: c_rate_udtcol,
2010: to_char(i_life_gen_new),
2011: p_effective_date))
2012: + to_number(pay_jp_report_pkg.get_udt_value(
2013: p_business_group_id,
2014: c_life_gen_new_calc_udt,
2015: c_add_adj_udtcol,
2016: to_char(i_life_gen_new),

Line 2034: * to_number(pay_jp_report_pkg.get_udt_value(

2030: end if;
2031: --
2032: -- udt satisfy validation of max value
2033: o_care_med_new := round(i_care_med_new
2034: * to_number(pay_jp_report_pkg.get_udt_value(
2035: p_business_group_id,
2036: c_life_gen_new_calc_udt,
2037: c_rate_udtcol,
2038: to_char(i_care_med_new),

Line 2040: + to_number(pay_jp_report_pkg.get_udt_value(

2036: c_life_gen_new_calc_udt,
2037: c_rate_udtcol,
2038: to_char(i_care_med_new),
2039: p_effective_date))
2040: + to_number(pay_jp_report_pkg.get_udt_value(
2041: p_business_group_id,
2042: c_life_gen_new_calc_udt,
2043: c_add_adj_udtcol,
2044: to_char(i_care_med_new),

Line 2066: * to_number(pay_jp_report_pkg.get_udt_value(

2062: end if;
2063: --
2064: -- udt satisfy validation of max value
2065: o_life_pens := round(i_life_pens
2066: * to_number(pay_jp_report_pkg.get_udt_value(
2067: p_business_group_id,
2068: c_life_pens_calc_udt,
2069: c_rate_udtcol,
2070: to_char(i_life_pens),

Line 2072: + to_number(pay_jp_report_pkg.get_udt_value(

2068: c_life_pens_calc_udt,
2069: c_rate_udtcol,
2070: to_char(i_life_pens),
2071: p_effective_date))
2072: + to_number(pay_jp_report_pkg.get_udt_value(
2073: p_business_group_id,
2074: c_life_pens_calc_udt,
2075: c_add_adj_udtcol,
2076: to_char(i_life_pens),

Line 2093: * to_number(pay_jp_report_pkg.get_udt_value(

2089: end if;
2090: --
2091: -- udt satisfy validation of max value
2092: o_life_pens_new := round(i_life_pens_new
2093: * to_number(pay_jp_report_pkg.get_udt_value(
2094: p_business_group_id,
2095: c_life_pens_new_calc_udt,
2096: c_rate_udtcol,
2097: to_char(i_life_pens_new),

Line 2099: + to_number(pay_jp_report_pkg.get_udt_value(

2095: c_life_pens_new_calc_udt,
2096: c_rate_udtcol,
2097: to_char(i_life_pens_new),
2098: p_effective_date))
2099: + to_number(pay_jp_report_pkg.get_udt_value(
2100: p_business_group_id,
2101: c_life_pens_new_calc_udt,
2102: c_add_adj_udtcol,
2103: to_char(i_life_pens_new),

Line 2198: * to_number(pay_jp_report_pkg.get_udt_value(

2194: end if;
2195: --
2196: -- udt satisfy validation of max value
2197: o_nonlife_long := round(i_nonlife_long
2198: * to_number(pay_jp_report_pkg.get_udt_value(
2199: p_business_group_id,
2200: c_nonlife_long_calc_udt,
2201: c_rate_udtcol,
2202: to_char(i_nonlife_long),

Line 2204: + to_number(pay_jp_report_pkg.get_udt_value(

2200: c_nonlife_long_calc_udt,
2201: c_rate_udtcol,
2202: to_char(i_nonlife_long),
2203: p_effective_date))
2204: + to_number(pay_jp_report_pkg.get_udt_value(
2205: p_business_group_id,
2206: c_nonlife_long_calc_udt,
2207: c_add_adj_udtcol,
2208: to_char(i_nonlife_long),

Line 2229: * to_number(pay_jp_report_pkg.get_udt_value(

2225: end if;
2226: --
2227: -- udt satisfy validation of max value
2228: o_nonlife_short := round(i_nonlife_short
2229: * to_number(pay_jp_report_pkg.get_udt_value(
2230: p_business_group_id,
2231: c_nonlife_short_calc_udt,
2232: c_rate_udtcol,
2233: to_char(i_nonlife_short),

Line 2235: + to_number(pay_jp_report_pkg.get_udt_value(

2231: c_nonlife_short_calc_udt,
2232: c_rate_udtcol,
2233: to_char(i_nonlife_short),
2234: p_effective_date))
2235: + to_number(pay_jp_report_pkg.get_udt_value(
2236: p_business_group_id,
2237: c_nonlife_short_calc_udt,
2238: c_add_adj_udtcol,
2239: to_char(i_nonlife_short),

Line 2255: c_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(

2251: or g_effective_date is null
2252: or c_nonlife_max is null then
2253: --
2254: -- need always reset cache has problem in case date is switched between 2006 and 2007.
2255: c_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(
2256: p_business_group_id,
2257: c_yea_calc_max_udt,
2258: c_max_udtcol,
2259: c_nonlife_udtrow,

Line 2295: c_earthquake_max := to_number(pay_jp_report_pkg.get_udt_value(

2291: end if;
2292: --
2293: o_earthquake := round(i_earthquake);
2294: if c_earthquake_max is null then
2295: c_earthquake_max := to_number(pay_jp_report_pkg.get_udt_value(
2296: p_business_group_id,
2297: c_yea_calc_max_udt,
2298: c_max_udtcol,
2299: c_earthquake_udtrow,

Line 2327: * to_number(pay_jp_report_pkg.get_udt_value(

2323: end if;
2324: --
2325: -- udt satisfy validation of max value
2326: o_nonlife_long := round(i_nonlife_long
2327: * to_number(pay_jp_report_pkg.get_udt_value(
2328: p_business_group_id,
2329: c_nonlife_long_calc_udt,
2330: c_rate_udtcol,
2331: to_char(i_nonlife_long),

Line 2333: + to_number(pay_jp_report_pkg.get_udt_value(

2329: c_nonlife_long_calc_udt,
2330: c_rate_udtcol,
2331: to_char(i_nonlife_long),
2332: p_effective_date))
2333: + to_number(pay_jp_report_pkg.get_udt_value(
2334: p_business_group_id,
2335: c_nonlife_long_calc_udt,
2336: c_add_adj_udtcol,
2337: to_char(i_nonlife_long),

Line 2357: c_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(

2353: or g_effective_date is null
2354: or c_nonlife_max is null then
2355: --
2356: -- need always reset cache has problem in case date is switched between 2006 and 2007.
2357: c_nonlife_max := to_number(pay_jp_report_pkg.get_udt_value(
2358: p_business_group_id,
2359: c_yea_calc_max_udt,
2360: c_max_udtcol,
2361: c_nonlife_udtrow,

Line 2653: c_emp_income_max := to_number(pay_jp_report_pkg.get_udt_value(

2649: end if;
2650: --
2651: if c_emp_income_max is null then
2652: --
2653: c_emp_income_max := to_number(pay_jp_report_pkg.get_udt_value(
2654: p_business_group_id,
2655: c_yea_calc_max_udt,
2656: c_max_udtcol,
2657: c_sp_emp_income_udtrow,

Line 2679: c_inc_spouse_dct_max := to_number(pay_jp_report_pkg.get_udt_value(

2675: end if;
2676: --
2677: if c_inc_spouse_dct_max is null then
2678: --
2679: c_inc_spouse_dct_max := to_number(pay_jp_report_pkg.get_udt_value(
2680: p_business_group_id,
2681: c_yea_calc_max_udt,
2682: c_max_udtcol,
2683: c_sp_dctable_sp_income_udtrow,

Line 2703: c_spouse_income_max := to_number(pay_jp_report_pkg.get_udt_value(

2699: end if;
2700: --
2701: if c_spouse_income_max is null then
2702: --
2703: c_spouse_income_max := to_number(pay_jp_report_pkg.get_udt_value(
2704: p_business_group_id,
2705: c_yea_calc_max_udt,
2706: c_max_udtcol,
2707: c_sp_spouse_income_udtrow,

Line 2720: o_spouse_dct := round(to_number(pay_jp_report_pkg.get_udt_value(

2716: end if;
2717: --
2718: if i_spouse_income < c_spouse_income_max then
2719: --
2720: o_spouse_dct := round(to_number(pay_jp_report_pkg.get_udt_value(
2721: p_business_group_id,
2722: c_spouse_calc_udt,
2723: c_dct_udtcol,
2724: to_char(i_spouse_income),