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

APPS.PAY_KR_YEA20100101_PKG dependencies on HRUSERDT

Line 192: l_multiplier := to_number(hruserdt.get_table_value(

188: function calc_tax(p_taxation_base in number) return number
189: is
190: begin
191: if p_taxation_base > 0 then
192: l_multiplier := to_number(hruserdt.get_table_value(
193: p_bus_group_id => p_business_group_id,
194: p_table_name => 'CALC_TAX',
195: p_col_name => 'MULTIPLIER',
196: p_row_value => to_char(p_taxation_base),

Line 198: l_subtrahend := to_number(hruserdt.get_table_value(

194: p_table_name => 'CALC_TAX',
195: p_col_name => 'MULTIPLIER',
196: p_row_value => to_char(p_taxation_base),
197: p_effective_date => p_effective_date));
198: l_subtrahend := to_number(hruserdt.get_table_value(
199: p_bus_group_id => p_business_group_id,
200: p_table_name => 'CALC_TAX',
201: p_col_name => 'SUBTRAHEND',
202: p_row_value => to_char(p_taxation_base),

Line 956: l_addend := to_number(hruserdt.get_table_value(

952: -- Basic Income Exemption
953: -- Taxable Income
954: ----------------------------------------------------------------
955: if p_yea_info.taxable > 0 then
956: l_addend := to_number(hruserdt.get_table_value(
957: p_bus_group_id => p_business_group_id,
958: p_table_name => 'BASIC_INCOME_EXEM',
959: p_col_name => 'ADDEND',
960: p_row_value => to_char(p_yea_info.taxable),

Line 962: l_multiplier := to_number(hruserdt.get_table_value(

958: p_table_name => 'BASIC_INCOME_EXEM',
959: p_col_name => 'ADDEND',
960: p_row_value => to_char(p_yea_info.taxable),
961: p_effective_date => p_effective_date));
962: l_multiplier := to_number(hruserdt.get_table_value(
963: p_bus_group_id => p_business_group_id,
964: p_table_name => 'BASIC_INCOME_EXEM',
965: p_col_name => 'MULTIPLIER',
966: p_row_value => to_char(p_yea_info.taxable),

Line 968: l_subtrahend := to_number(hruserdt.get_table_value(

964: p_table_name => 'BASIC_INCOME_EXEM',
965: p_col_name => 'MULTIPLIER',
966: p_row_value => to_char(p_yea_info.taxable),
967: p_effective_date => p_effective_date));
968: l_subtrahend := to_number(hruserdt.get_table_value(
969: p_bus_group_id => p_business_group_id,
970: p_table_name => 'BASIC_INCOME_EXEM',
971: p_col_name => 'SUBTRAHEND',
972: p_row_value => to_char(p_yea_info.taxable),

Line 2129: l_basic_tax_break := to_number(hruserdt.get_table_value(

2125:
2126: if l_dummy > 0 then
2127: -- Bug 9231094
2128: if p_effective_date > c_20120101 then
2129: l_basic_tax_break := to_number(hruserdt.get_table_value(
2130: p_bus_group_id => p_business_group_id,
2131: p_table_name => 'MAX_BASIC_TAX_BREAK',
2132: p_col_name => 'VALUE',
2133: p_row_value => to_char(p_yea_info.taxable),

Line 2137: l_addend := to_number(hruserdt.get_table_value(

2133: p_row_value => to_char(p_yea_info.taxable),
2134: p_effective_date => p_effective_date));
2135: end if;
2136:
2137: l_addend := to_number(hruserdt.get_table_value(
2138: p_bus_group_id => p_business_group_id,
2139: p_table_name => 'BASIC_TAX_BREAK',
2140: p_col_name => 'ADDEND',
2141: p_row_value => to_char(l_dummy),

Line 2143: l_subtrahend := to_number(hruserdt.get_table_value(

2139: p_table_name => 'BASIC_TAX_BREAK',
2140: p_col_name => 'ADDEND',
2141: p_row_value => to_char(l_dummy),
2142: p_effective_date => p_effective_date));
2143: l_subtrahend := to_number(hruserdt.get_table_value(
2144: p_bus_group_id => p_business_group_id,
2145: p_table_name => 'BASIC_TAX_BREAK',
2146: p_col_name => 'SUBTRAHEND',
2147: p_row_value => to_char(l_dummy),

Line 2149: l_multiplier := to_number(hruserdt.get_table_value(

2145: p_table_name => 'BASIC_TAX_BREAK',
2146: p_col_name => 'SUBTRAHEND',
2147: p_row_value => to_char(l_dummy),
2148: p_effective_date => p_effective_date));
2149: l_multiplier := to_number(hruserdt.get_table_value(
2150: p_bus_group_id => p_business_group_id,
2151: p_table_name => 'BASIC_TAX_BREAK',
2152: p_col_name => 'MULTIPLIER',
2153: p_row_value => to_char(l_dummy),

Line 2263: l_addend := to_number(hruserdt.get_table_value(

2259: p_yea_info.fw_contr_non_taxable_earn := p_yea_info.fw_contr_non_taxable_earn + l_fw_contr_fw_inc_exem ;
2260: end if ; */
2261: -- Deduct basic exemption on taxable income calculated till now
2262: if l_fw_contr_taxable > 0 then
2263: l_addend := to_number(hruserdt.get_table_value(
2264: p_bus_group_id => p_business_group_id,
2265: p_table_name => 'BASIC_INCOME_EXEM',
2266: p_col_name => 'ADDEND',
2267: p_row_value => to_char(l_fw_contr_taxable),

Line 2269: l_multiplier := to_number(hruserdt.get_table_value(

2265: p_table_name => 'BASIC_INCOME_EXEM',
2266: p_col_name => 'ADDEND',
2267: p_row_value => to_char(l_fw_contr_taxable),
2268: p_effective_date => p_effective_date));
2269: l_multiplier := to_number(hruserdt.get_table_value(
2270: p_bus_group_id => p_business_group_id,
2271: p_table_name => 'BASIC_INCOME_EXEM',
2272: p_col_name => 'MULTIPLIER',
2273: p_row_value => to_char(l_fw_contr_taxable),

Line 2275: l_subtrahend := to_number(hruserdt.get_table_value(

2271: p_table_name => 'BASIC_INCOME_EXEM',
2272: p_col_name => 'MULTIPLIER',
2273: p_row_value => to_char(l_fw_contr_taxable),
2274: p_effective_date => p_effective_date));
2275: l_subtrahend := to_number(hruserdt.get_table_value(
2276: p_bus_group_id => p_business_group_id,
2277: p_table_name => 'BASIC_INCOME_EXEM',
2278: p_col_name => 'SUBTRAHEND',
2279: p_row_value => to_char(l_fw_contr_taxable),