APPS.PAY_BALANCE_UPLOAD dependencies on HR_TAX_UNITS_V

Line 272: hr_tax_units_v view run very slow.

268: transfer mode.
269: 40.13 N.Bristow 11-Nov-1995 Now calling bal_adjust_actions to
270: perform the balance adjustment.
271: 40.12 N.Bristow 02-Nov-1995 Statements that reference the
272: hr_tax_units_v view run very slow.
273: Changed to access base tables.
274: 40.11 N.Bristow 23-Oct-1995 Now csr_batch_line_transfer ordering in
275: decending date order. Also reversed the
276: 10.7 changes with regard to the BF

Line 727: from hr_tax_units_v

723: ,p_tax_unit_id number
724: ) is
725: select upper(name) tax_unit_name,
726: tax_unit_id
727: from hr_tax_units_v
728: where business_group_id = p_business_group_id
729: and p_tax_unit_id = tax_unit_id
730: and p_tax_unit_id is not null
731: union all

Line 734: from hr_tax_units_v

730: and p_tax_unit_id is not null
731: union all
732: select upper(name) tax_unit_name,
733: tax_unit_id
734: from hr_tax_units_v
735: where business_group_id = p_business_group_id
736: and upper(name) = upper(p_gre_name)
737: and p_tax_unit_id is null;
738: --