DBA Data[Home] [Help]

APPS.PAY_KR_YEA20110101_PKG dependencies on HRUSERDT

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

195: function calc_tax(p_taxation_base in number) return number
196: is
197: begin
198: if p_taxation_base > 0 then
199: l_multiplier := to_number(hruserdt.get_table_value(
200: p_bus_group_id => p_business_group_id,
201: p_table_name => 'CALC_TAX',
202: p_col_name => 'MULTIPLIER',
203: p_row_value => to_char(p_taxation_base),

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

201: p_table_name => 'CALC_TAX',
202: p_col_name => 'MULTIPLIER',
203: p_row_value => to_char(p_taxation_base),
204: p_effective_date => p_effective_date));
205: l_subtrahend := to_number(hruserdt.get_table_value(
206: p_bus_group_id => p_business_group_id,
207: p_table_name => 'CALC_TAX',
208: p_col_name => 'SUBTRAHEND',
209: p_row_value => to_char(p_taxation_base),

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

977: -- Basic Income Exemption
978: -- Taxable Income
979: ----------------------------------------------------------------
980: if p_yea_info.taxable > 0 then
981: l_addend := to_number(hruserdt.get_table_value(
982: p_bus_group_id => p_business_group_id,
983: p_table_name => 'BASIC_INCOME_EXEM',
984: p_col_name => 'ADDEND',
985: p_row_value => to_char(p_yea_info.taxable),

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

983: p_table_name => 'BASIC_INCOME_EXEM',
984: p_col_name => 'ADDEND',
985: p_row_value => to_char(p_yea_info.taxable),
986: p_effective_date => p_effective_date));
987: l_multiplier := to_number(hruserdt.get_table_value(
988: p_bus_group_id => p_business_group_id,
989: p_table_name => 'BASIC_INCOME_EXEM',
990: p_col_name => 'MULTIPLIER',
991: p_row_value => to_char(p_yea_info.taxable),

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

989: p_table_name => 'BASIC_INCOME_EXEM',
990: p_col_name => 'MULTIPLIER',
991: p_row_value => to_char(p_yea_info.taxable),
992: p_effective_date => p_effective_date));
993: l_subtrahend := to_number(hruserdt.get_table_value(
994: p_bus_group_id => p_business_group_id,
995: p_table_name => 'BASIC_INCOME_EXEM',
996: p_col_name => 'SUBTRAHEND',
997: p_row_value => to_char(p_yea_info.taxable),

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

2364: l_available_tax_break := p_yea_info.calc_tax;
2365: --
2366:
2367: if l_dummy > 0 then
2368: l_addend := to_number(hruserdt.get_table_value(
2369: p_bus_group_id => p_business_group_id,
2370: p_table_name => 'BASIC_TAX_BREAK',
2371: p_col_name => 'ADDEND',
2372: p_row_value => to_char(l_dummy),

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

2370: p_table_name => 'BASIC_TAX_BREAK',
2371: p_col_name => 'ADDEND',
2372: p_row_value => to_char(l_dummy),
2373: p_effective_date => p_effective_date));
2374: l_subtrahend := to_number(hruserdt.get_table_value(
2375: p_bus_group_id => p_business_group_id,
2376: p_table_name => 'BASIC_TAX_BREAK',
2377: p_col_name => 'SUBTRAHEND',
2378: p_row_value => to_char(l_dummy),

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

2376: p_table_name => 'BASIC_TAX_BREAK',
2377: p_col_name => 'SUBTRAHEND',
2378: p_row_value => to_char(l_dummy),
2379: p_effective_date => p_effective_date));
2380: l_multiplier := to_number(hruserdt.get_table_value(
2381: p_bus_group_id => p_business_group_id,
2382: p_table_name => 'BASIC_TAX_BREAK',
2383: p_col_name => 'MULTIPLIER',
2384: p_row_value => to_char(l_dummy),

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

2490: p_yea_info.fw_contr_non_taxable_earn := p_yea_info.fw_contr_non_taxable_earn + l_fw_contr_fw_inc_exem ;
2491: end if ; */
2492: -- Deduct basic exemption on taxable income calculated till now
2493: if l_fw_contr_taxable > 0 then
2494: l_addend := to_number(hruserdt.get_table_value(
2495: p_bus_group_id => p_business_group_id,
2496: p_table_name => 'BASIC_INCOME_EXEM',
2497: p_col_name => 'ADDEND',
2498: p_row_value => to_char(l_fw_contr_taxable),

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

2496: p_table_name => 'BASIC_INCOME_EXEM',
2497: p_col_name => 'ADDEND',
2498: p_row_value => to_char(l_fw_contr_taxable),
2499: p_effective_date => p_effective_date));
2500: l_multiplier := to_number(hruserdt.get_table_value(
2501: p_bus_group_id => p_business_group_id,
2502: p_table_name => 'BASIC_INCOME_EXEM',
2503: p_col_name => 'MULTIPLIER',
2504: p_row_value => to_char(l_fw_contr_taxable),

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

2502: p_table_name => 'BASIC_INCOME_EXEM',
2503: p_col_name => 'MULTIPLIER',
2504: p_row_value => to_char(l_fw_contr_taxable),
2505: p_effective_date => p_effective_date));
2506: l_subtrahend := to_number(hruserdt.get_table_value(
2507: p_bus_group_id => p_business_group_id,
2508: p_table_name => 'BASIC_INCOME_EXEM',
2509: p_col_name => 'SUBTRAHEND',
2510: p_row_value => to_char(l_fw_contr_taxable),