DBA Data[Home] [Help]

APPS.PAY_KR_YEA20070101_PKG dependencies on HRUSERDT

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

135: function calc_tax(p_taxation_base in number) return number
136: is
137: begin
138: if p_taxation_base > 0 then
139: l_multiplier := 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 => 'MULTIPLIER',
143: p_row_value => to_char(p_taxation_base),

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

141: p_table_name => 'CALC_TAX',
142: p_col_name => 'MULTIPLIER',
143: p_row_value => to_char(p_taxation_base),
144: p_effective_date => p_effective_date));
145: l_subtrahend := to_number(hruserdt.get_table_value(
146: p_bus_group_id => p_business_group_id,
147: p_table_name => 'CALC_TAX',
148: p_col_name => 'SUBTRAHEND',
149: p_row_value => to_char(p_taxation_base),

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

346: -- Basic Income Exemption
347: -- Taxable Income
348: ----------------------------------------------------------------
349: if p_yea_info.taxable > 0 then
350: l_addend := to_number(hruserdt.get_table_value(
351: p_bus_group_id => p_business_group_id,
352: p_table_name => 'BASIC_INCOME_EXEM',
353: p_col_name => 'ADDEND',
354: p_row_value => to_char(p_yea_info.taxable),

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

352: p_table_name => 'BASIC_INCOME_EXEM',
353: p_col_name => 'ADDEND',
354: p_row_value => to_char(p_yea_info.taxable),
355: p_effective_date => p_effective_date));
356: l_multiplier := to_number(hruserdt.get_table_value(
357: p_bus_group_id => p_business_group_id,
358: p_table_name => 'BASIC_INCOME_EXEM',
359: p_col_name => 'MULTIPLIER',
360: p_row_value => to_char(p_yea_info.taxable),

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

358: p_table_name => 'BASIC_INCOME_EXEM',
359: p_col_name => 'MULTIPLIER',
360: p_row_value => to_char(p_yea_info.taxable),
361: p_effective_date => p_effective_date));
362: l_subtrahend := to_number(hruserdt.get_table_value(
363: p_bus_group_id => p_business_group_id,
364: p_table_name => 'BASIC_INCOME_EXEM',
365: p_col_name => 'SUBTRAHEND',
366: p_row_value => to_char(p_yea_info.taxable),

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

938: --
939: l_available_tax_break := p_yea_info.calc_tax;
940: --
941: if l_dummy > 0 then
942: l_addend := to_number(hruserdt.get_table_value(
943: p_bus_group_id => p_business_group_id,
944: p_table_name => 'BASIC_TAX_BREAK',
945: p_col_name => 'ADDEND',
946: p_row_value => to_char(l_dummy),

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

944: p_table_name => 'BASIC_TAX_BREAK',
945: p_col_name => 'ADDEND',
946: p_row_value => to_char(l_dummy),
947: p_effective_date => p_effective_date));
948: l_subtrahend := to_number(hruserdt.get_table_value(
949: p_bus_group_id => p_business_group_id,
950: p_table_name => 'BASIC_TAX_BREAK',
951: p_col_name => 'SUBTRAHEND',
952: p_row_value => to_char(l_dummy),

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

950: p_table_name => 'BASIC_TAX_BREAK',
951: p_col_name => 'SUBTRAHEND',
952: p_row_value => to_char(l_dummy),
953: p_effective_date => p_effective_date));
954: l_multiplier := to_number(hruserdt.get_table_value(
955: p_bus_group_id => p_business_group_id,
956: p_table_name => 'BASIC_TAX_BREAK',
957: p_col_name => 'MULTIPLIER',
958: p_row_value => to_char(l_dummy),

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

1043: end if ;
1044:
1045: -- Deduct basic exemption on taxable income calculated till now
1046: if l_fw_contr_taxable > 0 then
1047: l_addend := to_number(hruserdt.get_table_value(
1048: p_bus_group_id => p_business_group_id,
1049: p_table_name => 'BASIC_INCOME_EXEM',
1050: p_col_name => 'ADDEND',
1051: p_row_value => to_char(l_fw_contr_taxable),

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

1049: p_table_name => 'BASIC_INCOME_EXEM',
1050: p_col_name => 'ADDEND',
1051: p_row_value => to_char(l_fw_contr_taxable),
1052: p_effective_date => p_effective_date));
1053: l_multiplier := to_number(hruserdt.get_table_value(
1054: p_bus_group_id => p_business_group_id,
1055: p_table_name => 'BASIC_INCOME_EXEM',
1056: p_col_name => 'MULTIPLIER',
1057: p_row_value => to_char(l_fw_contr_taxable),

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

1055: p_table_name => 'BASIC_INCOME_EXEM',
1056: p_col_name => 'MULTIPLIER',
1057: p_row_value => to_char(l_fw_contr_taxable),
1058: p_effective_date => p_effective_date));
1059: l_subtrahend := to_number(hruserdt.get_table_value(
1060: p_bus_group_id => p_business_group_id,
1061: p_table_name => 'BASIC_INCOME_EXEM',
1062: p_col_name => 'SUBTRAHEND',
1063: p_row_value => to_char(l_fw_contr_taxable),