DBA Data[Home] [Help]

APPS.PAY_AU_BAL_UPLOAD dependencies on HR_TAX_UNITS_V

Line 356: ,hr_tax_units_v htuv

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

Line 363: ,hr_tax_units_v htuv

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: