APPS.PAY_KR_YEA20090101_PKG dependencies on HRUSERDT

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

150: function calc_tax(p_taxation_base in number) return number
151: is
152: begin
153: if p_taxation_base > 0 then
154: l_multiplier := to_number(hruserdt.get_table_value(
155: p_bus_group_id => p_business_group_id,
156: p_table_name => 'CALC_TAX',
157: p_col_name => 'MULTIPLIER',
158: p_row_value => to_char(p_taxation_base),

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

156: p_table_name => 'CALC_TAX',
157: p_col_name => 'MULTIPLIER',
158: p_row_value => to_char(p_taxation_base),
159: p_effective_date => p_effective_date));
160: l_subtrahend := to_number(hruserdt.get_table_value(
161: p_bus_group_id => p_business_group_id,
162: p_table_name => 'CALC_TAX',
163: p_col_name => 'SUBTRAHEND',
164: p_row_value => to_char(p_taxation_base),

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

404: -- Basic Income Exemption
405: -- Taxable Income
406: ----------------------------------------------------------------
407: if p_yea_info.taxable > 0 then
408: l_addend := to_number(hruserdt.get_table_value(
409: p_bus_group_id => p_business_group_id,
410: p_table_name => 'BASIC_INCOME_EXEM',
411: p_col_name => 'ADDEND',
412: p_row_value => to_char(p_yea_info.taxable),

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

410: p_table_name => 'BASIC_INCOME_EXEM',
411: p_col_name => 'ADDEND',
412: p_row_value => to_char(p_yea_info.taxable),
413: p_effective_date => p_effective_date));
414: l_multiplier := to_number(hruserdt.get_table_value(
415: p_bus_group_id => p_business_group_id,
416: p_table_name => 'BASIC_INCOME_EXEM',
417: p_col_name => 'MULTIPLIER',
418: p_row_value => to_char(p_yea_info.taxable),

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

416: p_table_name => 'BASIC_INCOME_EXEM',
417: p_col_name => 'MULTIPLIER',
418: p_row_value => to_char(p_yea_info.taxable),
419: p_effective_date => p_effective_date));
420: l_subtrahend := to_number(hruserdt.get_table_value(
421: p_bus_group_id => p_business_group_id,
422: p_table_name => 'BASIC_INCOME_EXEM',
423: p_col_name => 'SUBTRAHEND',
424: p_row_value => to_char(p_yea_info.taxable),

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

1119: --
1120: l_available_tax_break := p_yea_info.calc_tax;
1121: --
1122: if l_dummy > 0 then
1123: l_addend := to_number(hruserdt.get_table_value(
1124: p_bus_group_id => p_business_group_id,
1125: p_table_name => 'BASIC_TAX_BREAK',
1126: p_col_name => 'ADDEND',
1127: p_row_value => to_char(l_dummy),

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

1125: p_table_name => 'BASIC_TAX_BREAK',
1126: p_col_name => 'ADDEND',
1127: p_row_value => to_char(l_dummy),
1128: p_effective_date => p_effective_date));
1129: l_subtrahend := to_number(hruserdt.get_table_value(
1130: p_bus_group_id => p_business_group_id,
1131: p_table_name => 'BASIC_TAX_BREAK',
1132: p_col_name => 'SUBTRAHEND',
1133: p_row_value => to_char(l_dummy),

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

1131: p_table_name => 'BASIC_TAX_BREAK',
1132: p_col_name => 'SUBTRAHEND',
1133: p_row_value => to_char(l_dummy),
1134: p_effective_date => p_effective_date));
1135: l_multiplier := to_number(hruserdt.get_table_value(
1136: p_bus_group_id => p_business_group_id,
1137: p_table_name => 'BASIC_TAX_BREAK',
1138: p_col_name => 'MULTIPLIER',
1139: p_row_value => to_char(l_dummy),

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

1241: end if ;
1242:
1243: -- Deduct basic exemption on taxable income calculated till now
1244: if l_fw_contr_taxable > 0 then
1245: l_addend := to_number(hruserdt.get_table_value(
1246: p_bus_group_id => p_business_group_id,
1247: p_table_name => 'BASIC_INCOME_EXEM',
1248: p_col_name => 'ADDEND',
1249: p_row_value => to_char(l_fw_contr_taxable),

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

1247: p_table_name => 'BASIC_INCOME_EXEM',
1248: p_col_name => 'ADDEND',
1249: p_row_value => to_char(l_fw_contr_taxable),
1250: p_effective_date => p_effective_date));
1251: l_multiplier := to_number(hruserdt.get_table_value(
1252: p_bus_group_id => p_business_group_id,
1253: p_table_name => 'BASIC_INCOME_EXEM',
1254: p_col_name => 'MULTIPLIER',
1255: p_row_value => to_char(l_fw_contr_taxable),

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

1253: p_table_name => 'BASIC_INCOME_EXEM',
1254: p_col_name => 'MULTIPLIER',
1255: p_row_value => to_char(l_fw_contr_taxable),
1256: p_effective_date => p_effective_date));
1257: l_subtrahend := to_number(hruserdt.get_table_value(
1258: p_bus_group_id => p_business_group_id,
1259: p_table_name => 'BASIC_INCOME_EXEM',
1260: p_col_name => 'SUBTRAHEND',
1261: p_row_value => to_char(l_fw_contr_taxable),