189: If L_LOCATION_ID is null Then
190: Begin
191: select name
192: into l_org_name
193: from hr_all_organization_units
194: where organization_id = rec.organization_id;
195: Exception
196: when no_data_found then
197: l_org_name := Null;