APPS.PAY_KR_YEA20120101_PKG dependencies on HRUSERDT

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

215: function calc_tax(p_taxation_base in number) return number
216: is
217: begin
218: if p_taxation_base > 0 then
219: l_multiplier := to_number(hruserdt.get_table_value(
220: p_bus_group_id => p_business_group_id,
221: p_table_name => 'CALC_TAX',
222: p_col_name => 'MULTIPLIER',
223: p_row_value => to_char(p_taxation_base),

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

221: p_table_name => 'CALC_TAX',
222: p_col_name => 'MULTIPLIER',
223: p_row_value => to_char(p_taxation_base),
224: p_effective_date => p_effective_date));
225: l_subtrahend := to_number(hruserdt.get_table_value(
226: p_bus_group_id => p_business_group_id,
227: p_table_name => 'CALC_TAX',
228: p_col_name => 'SUBTRAHEND',
229: p_row_value => to_char(p_taxation_base),

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

1010: -- Basic Income Exemption
1011: -- Taxable Income
1012: ----------------------------------------------------------------
1013: if p_yea_info.taxable > 0 then
1014: l_addend := to_number(hruserdt.get_table_value(
1015: p_bus_group_id => p_business_group_id,
1016: p_table_name => 'BASIC_INCOME_EXEM',
1017: p_col_name => 'ADDEND',
1018: p_row_value => to_char(p_yea_info.taxable),

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

1016: p_table_name => 'BASIC_INCOME_EXEM',
1017: p_col_name => 'ADDEND',
1018: p_row_value => to_char(p_yea_info.taxable),
1019: p_effective_date => p_effective_date));
1020: l_multiplier := to_number(hruserdt.get_table_value(
1021: p_bus_group_id => p_business_group_id,
1022: p_table_name => 'BASIC_INCOME_EXEM',
1023: p_col_name => 'MULTIPLIER',
1024: p_row_value => to_char(p_yea_info.taxable),

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

1022: p_table_name => 'BASIC_INCOME_EXEM',
1023: p_col_name => 'MULTIPLIER',
1024: p_row_value => to_char(p_yea_info.taxable),
1025: p_effective_date => p_effective_date));
1026: l_subtrahend := to_number(hruserdt.get_table_value(
1027: p_bus_group_id => p_business_group_id,
1028: p_table_name => 'BASIC_INCOME_EXEM',
1029: p_col_name => 'SUBTRAHEND',
1030: p_row_value => to_char(p_yea_info.taxable),

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

2257: l_available_tax_break := p_yea_info.calc_tax;
2258: --
2259:
2260: if l_dummy > 0 then
2261: l_addend := to_number(hruserdt.get_table_value(
2262: p_bus_group_id => p_business_group_id,
2263: p_table_name => 'BASIC_TAX_BREAK',
2264: p_col_name => 'ADDEND',
2265: p_row_value => to_char(l_dummy),

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

2263: p_table_name => 'BASIC_TAX_BREAK',
2264: p_col_name => 'ADDEND',
2265: p_row_value => to_char(l_dummy),
2266: p_effective_date => p_effective_date));
2267: l_subtrahend := to_number(hruserdt.get_table_value(
2268: p_bus_group_id => p_business_group_id,
2269: p_table_name => 'BASIC_TAX_BREAK',
2270: p_col_name => 'SUBTRAHEND',
2271: p_row_value => to_char(l_dummy),

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

2269: p_table_name => 'BASIC_TAX_BREAK',
2270: p_col_name => 'SUBTRAHEND',
2271: p_row_value => to_char(l_dummy),
2272: p_effective_date => p_effective_date));
2273: l_multiplier := to_number(hruserdt.get_table_value(
2274: p_bus_group_id => p_business_group_id,
2275: p_table_name => 'BASIC_TAX_BREAK',
2276: p_col_name => 'MULTIPLIER',
2277: p_row_value => to_char(l_dummy),

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

2386: p_yea_info.fw_contr_non_taxable_earn := p_yea_info.fw_contr_non_taxable_earn + l_fw_contr_fw_inc_exem ;
2387: end if ; */
2388: -- Deduct basic exemption on taxable income calculated till now
2389: if l_fw_contr_taxable > 0 then
2390: l_addend := to_number(hruserdt.get_table_value(
2391: p_bus_group_id => p_business_group_id,
2392: p_table_name => 'BASIC_INCOME_EXEM',
2393: p_col_name => 'ADDEND',
2394: p_row_value => to_char(l_fw_contr_taxable),

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

2392: p_table_name => 'BASIC_INCOME_EXEM',
2393: p_col_name => 'ADDEND',
2394: p_row_value => to_char(l_fw_contr_taxable),
2395: p_effective_date => p_effective_date));
2396: l_multiplier := to_number(hruserdt.get_table_value(
2397: p_bus_group_id => p_business_group_id,
2398: p_table_name => 'BASIC_INCOME_EXEM',
2399: p_col_name => 'MULTIPLIER',
2400: p_row_value => to_char(l_fw_contr_taxable),

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

2398: p_table_name => 'BASIC_INCOME_EXEM',
2399: p_col_name => 'MULTIPLIER',
2400: p_row_value => to_char(l_fw_contr_taxable),
2401: p_effective_date => p_effective_date));
2402: l_subtrahend := to_number(hruserdt.get_table_value(
2403: p_bus_group_id => p_business_group_id,
2404: p_table_name => 'BASIC_INCOME_EXEM',
2405: p_col_name => 'SUBTRAHEND',
2406: p_row_value => to_char(l_fw_contr_taxable),