352:
353: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER) IS
354: SELECT htuv.tax_unit_id
355: FROM pay_balance_batch_lines pbbl
356: ,hr_tax_units_v htuv
357: WHERE pbbl.batch_line_id = p_batch_line_id
358: AND pbbl.tax_unit_id = htuv.tax_unit_id
359: AND pbbl.tax_unit_id IS NOT NULL
360: UNION ALL
359: AND pbbl.tax_unit_id IS NOT NULL
360: UNION ALL
361: SELECT htuv.tax_unit_id
362: FROM pay_balance_batch_lines pbbl
363: ,hr_tax_units_v htuv
364: WHERE pbbl.batch_line_id = p_batch_line_id
365: AND upper(pbbl.gre_name) = UPPER(htuv.name)
366: AND pbbl.tax_unit_id IS NULL;
367: