DBA Data[Home] [Help]

APPS.PAY_SG_BAL_UPLOAD dependencies on HR_TAX_UNITS_V

Line 457: ,hr_tax_units_v htuv

453: p_batch_line_id number
454: ) is
455: select htuv.tax_unit_id
456: from pay_balance_batch_lines pbbl
457: ,hr_tax_units_v htuv
458: where pbbl.batch_line_id = p_batch_line_id
459: and pbbl.tax_unit_id = htuv.tax_unit_id
460: and pbbl.tax_unit_id is not null
461: union all

Line 464: ,hr_tax_units_v htuv

460: and pbbl.tax_unit_id is not null
461: union all
462: select htuv.tax_unit_id
463: from pay_balance_batch_lines pbbl
464: ,hr_tax_units_v htuv
465: where pbbl.batch_line_id = p_batch_line_id
466: and upper(pbbl.gre_name) = upper(htuv.name)
467: and pbbl.tax_unit_id is null;
468: --