APPS.PAY_ES_COURT_ORDER_DEDUCTION dependencies on HR_UTILITY

Line 40: hr_utility.trace('High Val :'||l_rec.high_value||' Low Val :'||l_rec.low_value);

36: l_salary := p_annual_salary;
37: FOR l_rec in csr_get_table_range(p_annual_salary
38: ,p_minimum_wage
39: ,p_effective_date) LOOP
40: hr_utility.trace('High Val :'||l_rec.high_value||' Low Val :'||l_rec.low_value);
41: BEGIN
42: l_perc := hruserdt.get_table_value(p_bus_group_id => p_business_gr_id
43: ,p_table_name => 'ES_COURT_ORDER_DEDUCTION_SCALE'
44: ,p_col_name => 'DEDUCTION_SCALE'

Line 51: hr_utility.trace('High Val :'||l_rec.high_value||' Low Val :'||l_rec.low_value||' perc :'||l_perc);

47: EXCEPTION
48: WHEN NO_DATA_FOUND THEN
49: l_perc := 0;
50: END;
51: hr_utility.trace('High Val :'||l_rec.high_value||' Low Val :'||l_rec.low_value||' perc :'||l_perc);
52: l_co_deduction := l_co_deduction + (LEAST(p_minimum_wage, l_salary)* l_perc/100);
53: l_salary := l_salary - p_minimum_wage;
54: END LOOP;
55: