APPS.CSP_REPAIR_ORDER_PKG dependencies on HR_ALL_ORGANIZATION_UNITS
Line 107: from hr_all_organization_units
103: BEGIN
104: IF (l_source_type = 'REPAIR') THEN
105: select name
106: into l_supplier_name 107: from hr_all_organization_units 108: where organization_id = l_Repair_supplier_id;
109: ELSE
110: select vendor_name
111: into l_supplier_name