DBA Data[Home] [Help]

APPS.PAY_KR_YEA20030101_PKG dependencies on HRUSERDT

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

95: function calc_tax(p_taxation_base in number) return number
96: is
97: begin
98: if p_taxation_base > 0 then
99: l_multiplier := to_number(hruserdt.get_table_value(
100: p_bus_group_id => p_business_group_id,
101: p_table_name => 'CALC_TAX',
102: p_col_name => 'MULTIPLIER',
103: p_row_value => to_char(p_taxation_base),

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

101: p_table_name => 'CALC_TAX',
102: p_col_name => 'MULTIPLIER',
103: p_row_value => to_char(p_taxation_base),
104: p_effective_date => p_effective_date));
105: l_subtrahend := to_number(hruserdt.get_table_value(
106: p_bus_group_id => p_business_group_id,
107: p_table_name => 'CALC_TAX',
108: p_col_name => 'SUBTRAHEND',
109: p_row_value => to_char(p_taxation_base),

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

203: -- Basic Income Exemption
204: -- Taxable Income
205: ----------------------------------------------------------------
206: if p_yea_info.taxable > 0 then
207: l_addend := to_number(hruserdt.get_table_value(
208: p_bus_group_id => p_business_group_id,
209: p_table_name => 'BASIC_INCOME_EXEM',
210: p_col_name => 'ADDEND',
211: p_row_value => to_char(p_yea_info.taxable),

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

209: p_table_name => 'BASIC_INCOME_EXEM',
210: p_col_name => 'ADDEND',
211: p_row_value => to_char(p_yea_info.taxable),
212: p_effective_date => p_effective_date));
213: l_multiplier := to_number(hruserdt.get_table_value(
214: p_bus_group_id => p_business_group_id,
215: p_table_name => 'BASIC_INCOME_EXEM',
216: p_col_name => 'MULTIPLIER',
217: p_row_value => to_char(p_yea_info.taxable),

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

215: p_table_name => 'BASIC_INCOME_EXEM',
216: p_col_name => 'MULTIPLIER',
217: p_row_value => to_char(p_yea_info.taxable),
218: p_effective_date => p_effective_date));
219: l_subtrahend := to_number(hruserdt.get_table_value(
220: p_bus_group_id => p_business_group_id,
221: p_table_name => 'BASIC_INCOME_EXEM',
222: p_col_name => 'SUBTRAHEND',
223: p_row_value => to_char(p_yea_info.taxable),

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

640: -- Bug 3174643
641: l_available_tax_break := p_yea_info.calc_tax;
642: --
643: if l_dummy > 0 then
644: l_addend := to_number(hruserdt.get_table_value(
645: p_bus_group_id => p_business_group_id,
646: p_table_name => 'BASIC_TAX_BREAK',
647: p_col_name => 'ADDEND',
648: p_row_value => to_char(l_dummy),

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

646: p_table_name => 'BASIC_TAX_BREAK',
647: p_col_name => 'ADDEND',
648: p_row_value => to_char(l_dummy),
649: p_effective_date => p_effective_date));
650: l_subtrahend := to_number(hruserdt.get_table_value(
651: p_bus_group_id => p_business_group_id,
652: p_table_name => 'BASIC_TAX_BREAK',
653: p_col_name => 'SUBTRAHEND',
654: p_row_value => to_char(l_dummy),

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

652: p_table_name => 'BASIC_TAX_BREAK',
653: p_col_name => 'SUBTRAHEND',
654: p_row_value => to_char(l_dummy),
655: p_effective_date => p_effective_date));
656: l_multiplier := to_number(hruserdt.get_table_value(
657: p_bus_group_id => p_business_group_id,
658: p_table_name => 'BASIC_TAX_BREAK',
659: p_col_name => 'MULTIPLIER',
660: p_row_value => to_char(l_dummy),