DBA Data[Home] [Help]

APPS.PAY_KR_YEA20080101_PKG dependencies on HRUSERDT

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

145: function calc_tax(p_taxation_base in number) return number
146: is
147: begin
148: if p_taxation_base > 0 then
149: l_multiplier := to_number(hruserdt.get_table_value(
150: p_bus_group_id => p_business_group_id,
151: p_table_name => 'CALC_TAX',
152: p_col_name => 'MULTIPLIER',
153: p_row_value => to_char(p_taxation_base),

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

151: p_table_name => 'CALC_TAX',
152: p_col_name => 'MULTIPLIER',
153: p_row_value => to_char(p_taxation_base),
154: p_effective_date => p_effective_date));
155: l_subtrahend := to_number(hruserdt.get_table_value(
156: p_bus_group_id => p_business_group_id,
157: p_table_name => 'CALC_TAX',
158: p_col_name => 'SUBTRAHEND',
159: p_row_value => to_char(p_taxation_base),

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

389: -- Basic Income Exemption
390: -- Taxable Income
391: ----------------------------------------------------------------
392: if p_yea_info.taxable > 0 then
393: l_addend := to_number(hruserdt.get_table_value(
394: p_bus_group_id => p_business_group_id,
395: p_table_name => 'BASIC_INCOME_EXEM',
396: p_col_name => 'ADDEND',
397: p_row_value => to_char(p_yea_info.taxable),

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

395: p_table_name => 'BASIC_INCOME_EXEM',
396: p_col_name => 'ADDEND',
397: p_row_value => to_char(p_yea_info.taxable),
398: p_effective_date => p_effective_date));
399: l_multiplier := to_number(hruserdt.get_table_value(
400: p_bus_group_id => p_business_group_id,
401: p_table_name => 'BASIC_INCOME_EXEM',
402: p_col_name => 'MULTIPLIER',
403: p_row_value => to_char(p_yea_info.taxable),

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

401: p_table_name => 'BASIC_INCOME_EXEM',
402: p_col_name => 'MULTIPLIER',
403: p_row_value => to_char(p_yea_info.taxable),
404: p_effective_date => p_effective_date));
405: l_subtrahend := to_number(hruserdt.get_table_value(
406: p_bus_group_id => p_business_group_id,
407: p_table_name => 'BASIC_INCOME_EXEM',
408: p_col_name => 'SUBTRAHEND',
409: p_row_value => to_char(p_yea_info.taxable),

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

1085: --
1086: l_available_tax_break := p_yea_info.calc_tax;
1087: --
1088: if l_dummy > 0 then
1089: l_addend := to_number(hruserdt.get_table_value(
1090: p_bus_group_id => p_business_group_id,
1091: p_table_name => 'BASIC_TAX_BREAK',
1092: p_col_name => 'ADDEND',
1093: p_row_value => to_char(l_dummy),

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

1091: p_table_name => 'BASIC_TAX_BREAK',
1092: p_col_name => 'ADDEND',
1093: p_row_value => to_char(l_dummy),
1094: p_effective_date => p_effective_date));
1095: l_subtrahend := to_number(hruserdt.get_table_value(
1096: p_bus_group_id => p_business_group_id,
1097: p_table_name => 'BASIC_TAX_BREAK',
1098: p_col_name => 'SUBTRAHEND',
1099: p_row_value => to_char(l_dummy),

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

1097: p_table_name => 'BASIC_TAX_BREAK',
1098: p_col_name => 'SUBTRAHEND',
1099: p_row_value => to_char(l_dummy),
1100: p_effective_date => p_effective_date));
1101: l_multiplier := to_number(hruserdt.get_table_value(
1102: p_bus_group_id => p_business_group_id,
1103: p_table_name => 'BASIC_TAX_BREAK',
1104: p_col_name => 'MULTIPLIER',
1105: p_row_value => to_char(l_dummy),

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

1207: end if ;
1208:
1209: -- Deduct basic exemption on taxable income calculated till now
1210: if l_fw_contr_taxable > 0 then
1211: l_addend := to_number(hruserdt.get_table_value(
1212: p_bus_group_id => p_business_group_id,
1213: p_table_name => 'BASIC_INCOME_EXEM',
1214: p_col_name => 'ADDEND',
1215: p_row_value => to_char(l_fw_contr_taxable),

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

1213: p_table_name => 'BASIC_INCOME_EXEM',
1214: p_col_name => 'ADDEND',
1215: p_row_value => to_char(l_fw_contr_taxable),
1216: p_effective_date => p_effective_date));
1217: l_multiplier := to_number(hruserdt.get_table_value(
1218: p_bus_group_id => p_business_group_id,
1219: p_table_name => 'BASIC_INCOME_EXEM',
1220: p_col_name => 'MULTIPLIER',
1221: p_row_value => to_char(l_fw_contr_taxable),

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

1219: p_table_name => 'BASIC_INCOME_EXEM',
1220: p_col_name => 'MULTIPLIER',
1221: p_row_value => to_char(l_fw_contr_taxable),
1222: p_effective_date => p_effective_date));
1223: l_subtrahend := to_number(hruserdt.get_table_value(
1224: p_bus_group_id => p_business_group_id,
1225: p_table_name => 'BASIC_INCOME_EXEM',
1226: p_col_name => 'SUBTRAHEND',
1227: p_row_value => to_char(l_fw_contr_taxable),