DBA Data[Home] [Help]

APPS.PAY_KR_YEA20020101_PKG dependencies on HRUSERDT

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

86: function calc_tax(p_taxation_base in number) return number
87: is
88: begin
89: if p_taxation_base > 0 then
90: l_multiplier := to_number(hruserdt.get_table_value(
91: p_bus_group_id => p_business_group_id,
92: p_table_name => 'CALC_TAX',
93: p_col_name => 'MULTIPLIER',
94: p_row_value => to_char(p_taxation_base),

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

92: p_table_name => 'CALC_TAX',
93: p_col_name => 'MULTIPLIER',
94: p_row_value => to_char(p_taxation_base),
95: p_effective_date => p_effective_date));
96: l_subtrahend := to_number(hruserdt.get_table_value(
97: p_bus_group_id => p_business_group_id,
98: p_table_name => 'CALC_TAX',
99: p_col_name => 'SUBTRAHEND',
100: p_row_value => to_char(p_taxation_base),

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

190: -- Basic Income Exemption
191: -- Taxable Income
192: ----------------------------------------------------------------
193: if p_yea_info.taxable > 0 then
194: l_addend := to_number(hruserdt.get_table_value(
195: p_bus_group_id => p_business_group_id,
196: p_table_name => 'BASIC_INCOME_EXEM',
197: p_col_name => 'ADDEND',
198: p_row_value => to_char(p_yea_info.taxable),

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

196: p_table_name => 'BASIC_INCOME_EXEM',
197: p_col_name => 'ADDEND',
198: p_row_value => to_char(p_yea_info.taxable),
199: p_effective_date => p_effective_date));
200: l_multiplier := to_number(hruserdt.get_table_value(
201: p_bus_group_id => p_business_group_id,
202: p_table_name => 'BASIC_INCOME_EXEM',
203: p_col_name => 'MULTIPLIER',
204: p_row_value => to_char(p_yea_info.taxable),

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

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

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

561: l_dummy := 0;
562: end if;
563: --
564: if l_dummy > 0 then
565: l_addend := to_number(hruserdt.get_table_value(
566: p_bus_group_id => p_business_group_id,
567: p_table_name => 'BASIC_TAX_BREAK',
568: p_col_name => 'ADDEND',
569: p_row_value => to_char(l_dummy),

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

567: p_table_name => 'BASIC_TAX_BREAK',
568: p_col_name => 'ADDEND',
569: p_row_value => to_char(l_dummy),
570: p_effective_date => p_effective_date));
571: l_subtrahend := to_number(hruserdt.get_table_value(
572: p_bus_group_id => p_business_group_id,
573: p_table_name => 'BASIC_TAX_BREAK',
574: p_col_name => 'SUBTRAHEND',
575: p_row_value => to_char(l_dummy),

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

573: p_table_name => 'BASIC_TAX_BREAK',
574: p_col_name => 'SUBTRAHEND',
575: p_row_value => to_char(l_dummy),
576: p_effective_date => p_effective_date));
577: l_multiplier := to_number(hruserdt.get_table_value(
578: p_bus_group_id => p_business_group_id,
579: p_table_name => 'BASIC_TAX_BREAK',
580: p_col_name => 'MULTIPLIER',
581: p_row_value => to_char(l_dummy),