DBA Data[Home] [Help]

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;