47: Else
48: hr_utility.set_location('.......Balance :'||p_balance_name||' and dimension :'||
49: p_dimension_name||' valid..',15);
50: Close csr_defined_bal;
51: hr_utility.set_location('.......Before Calling pay_balance_pkg.get_value function..',20);
52: pay_balance_pkg.set_context('tax_unit_id', p_business_group_id);
53: pay_balance_pkg.set_context('date_earned', p_effective_date);
54: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
55: p_assignment_id,
48: hr_utility.set_location('.......Balance :'||p_balance_name||' and dimension :'||
49: p_dimension_name||' valid..',15);
50: Close csr_defined_bal;
51: hr_utility.set_location('.......Before Calling pay_balance_pkg.get_value function..',20);
52: pay_balance_pkg.set_context('tax_unit_id', p_business_group_id);
53: pay_balance_pkg.set_context('date_earned', p_effective_date);
54: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
55: p_assignment_id,
56: p_effective_date);
49: p_dimension_name||' valid..',15);
50: Close csr_defined_bal;
51: hr_utility.set_location('.......Before Calling pay_balance_pkg.get_value function..',20);
52: pay_balance_pkg.set_context('tax_unit_id', p_business_group_id);
53: pay_balance_pkg.set_context('date_earned', p_effective_date);
54: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
55: p_assignment_id,
56: p_effective_date);
57: End If;
50: Close csr_defined_bal;
51: hr_utility.set_location('.......Before Calling pay_balance_pkg.get_value function..',20);
52: pay_balance_pkg.set_context('tax_unit_id', p_business_group_id);
53: pay_balance_pkg.set_context('date_earned', p_effective_date);
54: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
55: p_assignment_id,
56: p_effective_date);
57: End If;
58: hr_utility.set_location('.......Leaving: '||l_proc_name, 25);
548: --l_return_value := -1;
549: Else
550: Close csr_defined_bal;
551: l_return_value := 0;
552: pay_balance_pkg.set_context('tax_unit_id', l_tax_id);
553: pay_balance_pkg.set_context('date_earned', l_effective_date);
554: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
555: p_assignment_id,
556: l_effective_date);
549: Else
550: Close csr_defined_bal;
551: l_return_value := 0;
552: pay_balance_pkg.set_context('tax_unit_id', l_tax_id);
553: pay_balance_pkg.set_context('date_earned', l_effective_date);
554: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
555: p_assignment_id,
556: l_effective_date);
557: End If;
550: Close csr_defined_bal;
551: l_return_value := 0;
552: pay_balance_pkg.set_context('tax_unit_id', l_tax_id);
553: pay_balance_pkg.set_context('date_earned', l_effective_date);
554: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,
555: p_assignment_id,
556: l_effective_date);
557: End If;
558: p_balance_amount := nvl(l_balance_amount,0);