DBA Data[Home] [Help]

APPS.PAY_NL_CBS_FILE dependencies on STANDARD

Line 246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);

242: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);

Line 247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;

243: l_adv_hours:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
244: -- hr_utility.set_location('l_adv_hours'||l_adv_hours,425);
245:
246: -- hr_utility.set_location('Fetching Defined Balance ID for SI_INCOME_STANDARD_TAX',500);
247: l_defined_balance := 'SI_INCOME_STANDARD_TAX'||l_dimension;
248: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
249: l_si_std_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
250: -- hr_utility.set_location('l_si_std_tax'||l_si_std_tax,425);
251:

Line 258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);

254: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);

Line 259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;

255: l_si_spl_tax:=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
256: -- hr_utility.set_location('l_si_spl_tax'||l_si_spl_tax,425);
257:
258: -- hr_utility.set_location('Fetching Defined Balance ID for RETRO SI_INCOME_STANDARD_TAX',500);
259: l_defined_balance := 'RETRO_SI_INCOME_STANDARD_TAX'||l_dimension;
260: l_defined_balance_id:=pay_nl_general.get_defined_balance_id(l_defined_balance);
261: l_ret_si_std_tax :=nvl(pay_balance_pkg.get_value(l_defined_balance_id,p_assgt_act_id),0);
262: -- hr_utility.set_location('l_ret_si_std_tax'||l_ret_si_std_tax,425);
263:

Line 908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);

904: open csr_get_date_earned(p_max_assgt_act_id);
905: fetch csr_get_date_earned into l_date_earned;
906: close csr_get_date_Earned;
907:
908: l_element_type_id:=pay_nl_general.get_element_type_id('Standard Tax Deduction',l_date_earned);
909: l_tax_discount_input_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Tax Reduction Flag',l_date_earned);
910: l_tax_code_input_id := pay_nl_general.get_input_value_id(l_element_type_id,'Tax Code',l_date_earned);
911: l_labour_relation_code_id:=pay_nl_general.get_input_value_id(l_element_type_id,'Labour Tax Reduction Flag',l_date_earned);
912: