[Home] [Help]
145: SELECT
146: GEOGRAPHY_NAME
147: INTO CP_COUNTRY_NAME
148: FROM
149: HZ_GEOGRAPHIES
150: WHERE GEOGRAPHY_CODE = P_COUNTRY
151: AND GEOGRAPHY_TYPE = 'COUNTRY';
152: EXCEPTION
153: WHEN NO_DATA_FOUND THEN