784: IS
785:
786: CURSOR csr_get_territory_name(p_territory_code VARCHAR2) Is
787: SELECT territory_short_name
788: FROM fnd_territories_vl
789: WHERE territory_code = p_territory_code;
790:
791: l_country fnd_territories_vl.territory_short_name%TYPE;
792: BEGIN
787: SELECT territory_short_name
788: FROM fnd_territories_vl
789: WHERE territory_code = p_territory_code;
790:
791: l_country fnd_territories_vl.territory_short_name%TYPE;
792: BEGIN
793:
794: IF g_debug THEN
795: hr_utility.set_location(' Entering Function GET_COUNTRY_NAME',140);