APPS.RRS_SITES_PKG dependencies on FND_TERRITORIES_VL
Line 263: FROM HZ_LOCATIONS HL, FND_TERRITORIES_VL FTV
259: IS
260: BEGIN
261: SELECT HL.COUNTRY,FTV.TERRITORY_SHORT_NAME
262: INTO x_country_code,x_country_name 263: FROM HZ_LOCATIONS HL, FND_TERRITORIES_VL FTV 264: WHERE FTV.TERRITORY_CODE = HL.COUNTRY
265: AND HL.LOCATION_ID = p_location_id;
266: END GET_COUNTRYCODE;
267: END RRS_SITES_PKG;