705:
706: hr_utility.trace('Setting context');
707:
708: if l_tax_unit_context then
709: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
710: end if;
711:
712: begin
713: select paa1.assignment_action_id
2229: /* To get balances you must use the highest assignment action . Since
2230: T4A does not have Jurisdiction specific balances first we have to
2231: sum up balances for all jurisdictions. */
2232:
2233: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2234: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2235:
2236: hr_utility.trace('i is ' ||to_char(i));
2237: hr_utility.trace('Balance type is ' ||l_balance_type_tab(i));
2230: T4A does not have Jurisdiction specific balances first we have to
2231: sum up balances for all jurisdictions. */
2232:
2233: pay_ca_balance_view_pkg.set_context('TAX_UNIT_ID',l_tax_unit_id);
2234: pay_ca_balance_view_pkg.set_context ('ASSIGNMENT_ACTION_ID',l_aaid);
2235:
2236: hr_utility.trace('i is ' ||to_char(i));
2237: hr_utility.trace('Balance type is ' ||l_balance_type_tab(i));
2238: hr_utility.trace('AAID is ' || to_char(l_aaid));