DBA Data[Home] [Help]

APPS.PAY_KR_YEA00010101_PKG dependencies on HRUSERDT

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

18: function calc_tax(p_taxation_base in number) return number
19: is
20: begin
21: if p_taxation_base > 0 then
22: l_multiplier := to_number(hruserdt.get_table_value(
23: p_bus_group_id => p_business_group_id,
24: p_table_name => 'CALC_TAX',
25: p_col_name => 'MULTIPLIER',
26: p_row_value => to_char(p_taxation_base),

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

24: p_table_name => 'CALC_TAX',
25: p_col_name => 'MULTIPLIER',
26: p_row_value => to_char(p_taxation_base),
27: p_effective_date => p_effective_date));
28: l_subtrahend := to_number(hruserdt.get_table_value(
29: p_bus_group_id => p_business_group_id,
30: p_table_name => 'CALC_TAX',
31: p_col_name => 'SUBTRAHEND',
32: p_row_value => to_char(p_taxation_base),

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

41: -- Basic Income Exemption
42: -- Taxable Income
43: ----------------------------------------------------------------
44: if p_yea_info.taxable > 0 then
45: l_addend := to_number(hruserdt.get_table_value(
46: p_bus_group_id => p_business_group_id,
47: p_table_name => 'BASIC_INCOME_EXEM',
48: p_col_name => 'ADDEND',
49: p_row_value => to_char(p_yea_info.taxable),

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

47: p_table_name => 'BASIC_INCOME_EXEM',
48: p_col_name => 'ADDEND',
49: p_row_value => to_char(p_yea_info.taxable),
50: p_effective_date => p_effective_date));
51: l_multiplier := to_number(hruserdt.get_table_value(
52: p_bus_group_id => p_business_group_id,
53: p_table_name => 'BASIC_INCOME_EXEM',
54: p_col_name => 'MULTIPLIER',
55: p_row_value => to_char(p_yea_info.taxable),

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

53: p_table_name => 'BASIC_INCOME_EXEM',
54: p_col_name => 'MULTIPLIER',
55: p_row_value => to_char(p_yea_info.taxable),
56: p_effective_date => p_effective_date));
57: l_subtrahend := to_number(hruserdt.get_table_value(
58: p_bus_group_id => p_business_group_id,
59: p_table_name => 'BASIC_INCOME_EXEM',
60: p_col_name => 'SUBTRAHEND',
61: p_row_value => to_char(p_yea_info.taxable),

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

344: l_dummy := 0;
345: end if;
346: --
347: if l_dummy > 0 then
348: l_addend := to_number(hruserdt.get_table_value(
349: p_bus_group_id => p_business_group_id,
350: p_table_name => 'BASIC_TAX_BREAK',
351: p_col_name => 'ADDEND',
352: p_row_value => to_char(l_dummy),

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

350: p_table_name => 'BASIC_TAX_BREAK',
351: p_col_name => 'ADDEND',
352: p_row_value => to_char(l_dummy),
353: p_effective_date => p_effective_date));
354: l_subtrahend := to_number(hruserdt.get_table_value(
355: p_bus_group_id => p_business_group_id,
356: p_table_name => 'BASIC_TAX_BREAK',
357: p_col_name => 'SUBTRAHEND',
358: p_row_value => to_char(l_dummy),

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

356: p_table_name => 'BASIC_TAX_BREAK',
357: p_col_name => 'SUBTRAHEND',
358: p_row_value => to_char(l_dummy),
359: p_effective_date => p_effective_date));
360: l_multiplier := to_number(hruserdt.get_table_value(
361: p_bus_group_id => p_business_group_id,
362: p_table_name => 'BASIC_TAX_BREAK',
363: p_col_name => 'MULTIPLIER',
364: p_row_value => to_char(l_dummy),