529: l_tax_unit_id NUMBER;
530:
531: CURSOR csr_bal_adj (p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
532: SELECT tba.original_entry_id
533: FROM pay_temp_balance_adjustments tba,
534: pay_balance_batch_lines bbl
535: WHERE tba.batch_line_id = p_test_batch_line_id
536: AND bbl.batch_line_id = p_batch_line_id
537: AND nvl(tba.original_entry_id,0) = nvl(bbl.original_entry_id,0);
537: AND nvl(tba.original_entry_id,0) = nvl(bbl.original_entry_id,0);
538:
539: CURSOR csr_bal_adj_tu (p_test_batch_line_id NUMBER, p_batch_line_id NUMBER) IS
540: SELECT tba.tax_unit_id
541: FROM pay_temp_balance_adjustments tba,
542: pay_balance_batch_lines bbl
543: WHERE tba.batch_line_id = p_test_batch_line_id
544: AND bbl.batch_line_id = p_batch_line_id
545: AND nvl(tba.tax_unit_id,0) = nvl(bbl.tax_unit_id,0);