113: SELECT
114: TERRITORY_SHORT_NAME
115: INTO COUNTRY_DESCRIPTION
116: FROM
117: FND_TERRITORIES_VL
118: WHERE TERRITORY_CODE = COUNTRY_CODE;
119: IF COUNTRY_DESCRIPTION IS NULL THEN
120: COUNTRY_DESCRIPTION := COUNTRY_CODE;
121: END IF;
124: SELECT
125: TERRITORY_SHORT_NAME
126: INTO COUNTRY_DESCRIPTION
127: FROM
128: FND_TERRITORIES_VL
129: WHERE TERRITORY_CODE = COUNTRY_CODE;
130: ELSE
131: COUNTRY_DESCRIPTION := NULL;
132: END IF;