DBA Data[Home] [Help]

APPS.PAY_KR_YEA20060101_PKG dependencies on HRUSERDT

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

129: function calc_tax(p_taxation_base in number) return number
130: is
131: begin
132: if p_taxation_base > 0 then
133: l_multiplier := to_number(hruserdt.get_table_value(
134: p_bus_group_id => p_business_group_id,
135: p_table_name => 'CALC_TAX',
136: p_col_name => 'MULTIPLIER',
137: p_row_value => to_char(p_taxation_base),

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

135: p_table_name => 'CALC_TAX',
136: p_col_name => 'MULTIPLIER',
137: p_row_value => to_char(p_taxation_base),
138: p_effective_date => p_effective_date));
139: l_subtrahend := to_number(hruserdt.get_table_value(
140: p_bus_group_id => p_business_group_id,
141: p_table_name => 'CALC_TAX',
142: p_col_name => 'SUBTRAHEND',
143: p_row_value => to_char(p_taxation_base),

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

331: -- Basic Income Exemption
332: -- Taxable Income
333: ----------------------------------------------------------------
334: if p_yea_info.taxable > 0 then
335: l_addend := to_number(hruserdt.get_table_value(
336: p_bus_group_id => p_business_group_id,
337: p_table_name => 'BASIC_INCOME_EXEM',
338: p_col_name => 'ADDEND',
339: p_row_value => to_char(p_yea_info.taxable),

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

337: p_table_name => 'BASIC_INCOME_EXEM',
338: p_col_name => 'ADDEND',
339: p_row_value => to_char(p_yea_info.taxable),
340: p_effective_date => p_effective_date));
341: l_multiplier := to_number(hruserdt.get_table_value(
342: p_bus_group_id => p_business_group_id,
343: p_table_name => 'BASIC_INCOME_EXEM',
344: p_col_name => 'MULTIPLIER',
345: p_row_value => to_char(p_yea_info.taxable),

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

343: p_table_name => 'BASIC_INCOME_EXEM',
344: p_col_name => 'MULTIPLIER',
345: p_row_value => to_char(p_yea_info.taxable),
346: p_effective_date => p_effective_date));
347: l_subtrahend := to_number(hruserdt.get_table_value(
348: p_bus_group_id => p_business_group_id,
349: p_table_name => 'BASIC_INCOME_EXEM',
350: p_col_name => 'SUBTRAHEND',
351: p_row_value => to_char(p_yea_info.taxable),

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

863: --
864: l_available_tax_break := p_yea_info.calc_tax;
865: --
866: if l_dummy > 0 then
867: l_addend := to_number(hruserdt.get_table_value(
868: p_bus_group_id => p_business_group_id,
869: p_table_name => 'BASIC_TAX_BREAK',
870: p_col_name => 'ADDEND',
871: p_row_value => to_char(l_dummy),

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

869: p_table_name => 'BASIC_TAX_BREAK',
870: p_col_name => 'ADDEND',
871: p_row_value => to_char(l_dummy),
872: p_effective_date => p_effective_date));
873: l_subtrahend := to_number(hruserdt.get_table_value(
874: p_bus_group_id => p_business_group_id,
875: p_table_name => 'BASIC_TAX_BREAK',
876: p_col_name => 'SUBTRAHEND',
877: p_row_value => to_char(l_dummy),

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

875: p_table_name => 'BASIC_TAX_BREAK',
876: p_col_name => 'SUBTRAHEND',
877: p_row_value => to_char(l_dummy),
878: p_effective_date => p_effective_date));
879: l_multiplier := to_number(hruserdt.get_table_value(
880: p_bus_group_id => p_business_group_id,
881: p_table_name => 'BASIC_TAX_BREAK',
882: p_col_name => 'MULTIPLIER',
883: p_row_value => to_char(l_dummy),

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

968: end if ;
969:
970: -- Deduct basic exemption on taxable income calculated till now
971: if l_fw_contr_taxable > 0 then
972: l_addend := to_number(hruserdt.get_table_value(
973: p_bus_group_id => p_business_group_id,
974: p_table_name => 'BASIC_INCOME_EXEM',
975: p_col_name => 'ADDEND',
976: p_row_value => to_char(l_fw_contr_taxable),

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

974: p_table_name => 'BASIC_INCOME_EXEM',
975: p_col_name => 'ADDEND',
976: p_row_value => to_char(l_fw_contr_taxable),
977: p_effective_date => p_effective_date));
978: l_multiplier := to_number(hruserdt.get_table_value(
979: p_bus_group_id => p_business_group_id,
980: p_table_name => 'BASIC_INCOME_EXEM',
981: p_col_name => 'MULTIPLIER',
982: p_row_value => to_char(l_fw_contr_taxable),

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

980: p_table_name => 'BASIC_INCOME_EXEM',
981: p_col_name => 'MULTIPLIER',
982: p_row_value => to_char(l_fw_contr_taxable),
983: p_effective_date => p_effective_date));
984: l_subtrahend := to_number(hruserdt.get_table_value(
985: p_bus_group_id => p_business_group_id,
986: p_table_name => 'BASIC_INCOME_EXEM',
987: p_col_name => 'SUBTRAHEND',
988: p_row_value => to_char(l_fw_contr_taxable),