PER_ALL_PEOPLE_F.country_of_birth in Oracle APPS

SELECT territory_code, territory_short_name

  FROM apps.fnd_territories_vl

 WHERE UPPER(TRIM (territory_short_name)) = UPPER(TRIM(:country_of_birth))