DBA Data[Home] [Help]

APPS.PAY_AU_BAL_UPLOAD dependencies on HR_TAX_UNITS_V

Line 358: ,hr_tax_units_v htuv

354:
355: CURSOR csr_get_tax_unit(p_batch_line_id NUMBER) IS
356: SELECT htuv.tax_unit_id
357: FROM pay_balance_batch_lines pbbl
358: ,hr_tax_units_v htuv
359: WHERE pbbl.batch_line_id = p_batch_line_id
360: AND pbbl.tax_unit_id = htuv.tax_unit_id
361: AND pbbl.tax_unit_id IS NOT NULL
362: UNION ALL

Line 365: ,hr_tax_units_v htuv

361: AND pbbl.tax_unit_id IS NOT NULL
362: UNION ALL
363: SELECT htuv.tax_unit_id
364: FROM pay_balance_batch_lines pbbl
365: ,hr_tax_units_v htuv
366: WHERE pbbl.batch_line_id = p_batch_line_id
367: AND upper(pbbl.gre_name) = UPPER(htuv.name)
368: AND pbbl.tax_unit_id IS NULL;
369: