APPS.PAY_BALANCE_UPLOAD dependencies on HR_TAX_UNITS_V

Line 274: hr_tax_units_v view run very slow.

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

Line 729: from hr_tax_units_v

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

Line 736: from hr_tax_units_v

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