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