DBA Data[Home] [Help]

APPS.PQP_US_SRS_EXTRACTS dependencies on PAY_BALANCE_PKG

Line 51: hr_utility.set_location('.......Before Calling pay_balance_pkg.get_value function..',20);

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,

Line 52: pay_balance_pkg.set_context('tax_unit_id', p_business_group_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);

Line 53: pay_balance_pkg.set_context('date_earned', 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;

Line 54: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,

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);

Line 552: pay_balance_pkg.set_context('tax_unit_id', l_tax_id);

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);

Line 553: pay_balance_pkg.set_context('date_earned', 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;

Line 554: l_balance_amount := pay_balance_pkg.get_value(l_defined_balance_id,

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);