DBA Data[Home] [Help]

APPS.PAY_HK_BAL_UPLOAD dependencies on HR_TAX_UNITS_V

Line 515: ,hr_tax_units_v htuv

511: p_batch_line_id number
512: ) is
513: select htuv.tax_unit_id
514: from pay_balance_batch_lines pbbl
515: ,hr_tax_units_v htuv
516: where pbbl.batch_line_id = p_batch_line_id
517: and pbbl.tax_unit_id = htuv.tax_unit_id
518: and pbbl.tax_unit_id is not null
519: union all

Line 522: ,hr_tax_units_v htuv

518: and pbbl.tax_unit_id is not null
519: union all
520: select htuv.tax_unit_id
521: from pay_balance_batch_lines pbbl
522: ,hr_tax_units_v htuv
523: where pbbl.batch_line_id = p_batch_line_id
524: and upper(pbbl.gre_name) = upper(htuv.name)
525: and pbbl.tax_unit_id is null;
526: --