DBA Data[Home] [Help]

APPS.PAY_CA_BAL_UPLOAD dependencies on HR_TAX_UNITS_V

Line 329: ,hr_tax_units_v htuv

325: p_batch_line_id number
326: ) is
327: select htuv.tax_unit_id
328: from pay_balance_batch_lines pbbl
329: ,hr_tax_units_v htuv
330: where pbbl.batch_line_id = p_batch_line_id
331: and pbbl.tax_unit_id = htuv.tax_unit_id
332: and pbbl.tax_unit_id is not null
333: union all

Line 336: ,hr_tax_units_v htuv

332: and pbbl.tax_unit_id is not null
333: union all
334: select htuv.tax_unit_id
335: from pay_balance_batch_lines pbbl
336: ,hr_tax_units_v htuv
337: where pbbl.batch_line_id = p_batch_line_id
338: and upper(pbbl.gre_name) = upper(htuv.name)
339: and pbbl.tax_unit_id is null;
340: --