DBA Data[Home] [Help]

APPS.HZ_DNBUI_PVT dependencies on FND_TERRITORIES_VL

Line 354: country_name fnd_territories_vl.TERRITORY_SHORT_NAME%TYPE;

350: +======================================================================*/
351:
352: function get_country_name(p_country_code IN VARCHAR2) RETURN VARCHAR2 IS
353:
354: country_name fnd_territories_vl.TERRITORY_SHORT_NAME%TYPE;
355:
356: BEGIN
357:
358: select TERRITORY_SHORT_NAME into country_name from fnd_territories_vl

Line 358: select TERRITORY_SHORT_NAME into country_name from fnd_territories_vl

354: country_name fnd_territories_vl.TERRITORY_SHORT_NAME%TYPE;
355:
356: BEGIN
357:
358: select TERRITORY_SHORT_NAME into country_name from fnd_territories_vl
359: where TERRITORY_CODE=p_country_code;
360:
361: return country_name;
362: