APPS.PAY_KR_YEA20080101_PKG dependencies on HRUSERDT

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

136: function calc_tax(p_taxation_base in number) return number
137: is
138: begin
139: if p_taxation_base > 0 then
140: l_multiplier := to_number(hruserdt.get_table_value(
141: p_bus_group_id => p_business_group_id,
142: p_table_name => 'CALC_TAX',
143: p_col_name => 'MULTIPLIER',
144: p_row_value => to_char(p_taxation_base),

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

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

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

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

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

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

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

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

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

953: --
954: l_available_tax_break := p_yea_info.calc_tax;
955: --
956: if l_dummy > 0 then
957: l_addend := to_number(hruserdt.get_table_value(
958: p_bus_group_id => p_business_group_id,
959: p_table_name => 'BASIC_TAX_BREAK',
960: p_col_name => 'ADDEND',
961: p_row_value => to_char(l_dummy),

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

959: p_table_name => 'BASIC_TAX_BREAK',
960: p_col_name => 'ADDEND',
961: p_row_value => to_char(l_dummy),
962: p_effective_date => p_effective_date));
963: l_subtrahend := to_number(hruserdt.get_table_value(
964: p_bus_group_id => p_business_group_id,
965: p_table_name => 'BASIC_TAX_BREAK',
966: p_col_name => 'SUBTRAHEND',
967: p_row_value => to_char(l_dummy),

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

965: p_table_name => 'BASIC_TAX_BREAK',
966: p_col_name => 'SUBTRAHEND',
967: p_row_value => to_char(l_dummy),
968: p_effective_date => p_effective_date));
969: l_multiplier := to_number(hruserdt.get_table_value(
970: p_bus_group_id => p_business_group_id,
971: p_table_name => 'BASIC_TAX_BREAK',
972: p_col_name => 'MULTIPLIER',
973: p_row_value => to_char(l_dummy),

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

1058: end if ;
1059:
1060: -- Deduct basic exemption on taxable income calculated till now
1061: if l_fw_contr_taxable > 0 then
1062: l_addend := to_number(hruserdt.get_table_value(
1063: p_bus_group_id => p_business_group_id,
1064: p_table_name => 'BASIC_INCOME_EXEM',
1065: p_col_name => 'ADDEND',
1066: p_row_value => to_char(l_fw_contr_taxable),

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

1064: p_table_name => 'BASIC_INCOME_EXEM',
1065: p_col_name => 'ADDEND',
1066: p_row_value => to_char(l_fw_contr_taxable),
1067: p_effective_date => p_effective_date));
1068: l_multiplier := to_number(hruserdt.get_table_value(
1069: p_bus_group_id => p_business_group_id,
1070: p_table_name => 'BASIC_INCOME_EXEM',
1071: p_col_name => 'MULTIPLIER',
1072: p_row_value => to_char(l_fw_contr_taxable),

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

1070: p_table_name => 'BASIC_INCOME_EXEM',
1071: p_col_name => 'MULTIPLIER',
1072: p_row_value => to_char(l_fw_contr_taxable),
1073: p_effective_date => p_effective_date));
1074: l_subtrahend := to_number(hruserdt.get_table_value(
1075: p_bus_group_id => p_business_group_id,
1076: p_table_name => 'BASIC_INCOME_EXEM',
1077: p_col_name => 'SUBTRAHEND',
1078: p_row_value => to_char(l_fw_contr_taxable),