1701: INTO l_defined_balance_id;
1702:
1703: CLOSE csr_def_bal_id;
1704:
1705: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1706: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1707: l_return_balance_value :=
1708: -- TO_CHAR (
1709: pay_balance_pkg.get_value
1702:
1703: CLOSE csr_def_bal_id;
1704:
1705: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1706: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1707: l_return_balance_value :=
1708: -- TO_CHAR (
1709: pay_balance_pkg.get_value
1710: (p_defined_balance_id => l_defined_balance_id
1705: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1706: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1707: l_return_balance_value :=
1708: -- TO_CHAR (
1709: pay_balance_pkg.get_value
1710: (p_defined_balance_id => l_defined_balance_id
1711: ,p_assignment_id => p_in_assignment_id
1712: ,p_virtual_date => p_in_virtual_date
1713: )
1757: CLOSE csr_def_bal_id;
1758:
1759: IF l_defined_balance_id IS NOT NULL
1760: THEN
1761: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1762: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1763: l_return_balance_value :=
1764: -- TO_CHAR (
1765: pay_balance_pkg.get_value
1758:
1759: IF l_defined_balance_id IS NOT NULL
1760: THEN
1761: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1762: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1763: l_return_balance_value :=
1764: -- TO_CHAR (
1765: pay_balance_pkg.get_value
1766: (p_defined_balance_id => l_defined_balance_id
1761: pay_balance_pkg.set_context ('TAX_UNIT_ID', p_tax_unit_id);
1762: pay_balance_pkg.set_context ('LOCAL_UNIT_ID', p_local_unit_id);
1763: l_return_balance_value :=
1764: -- TO_CHAR (
1765: pay_balance_pkg.get_value
1766: (p_defined_balance_id => l_defined_balance_id
1767: ,p_assignment_id => p_in_assignment_id
1768: ,p_virtual_date => p_in_virtual_date
1769: )