APPS.RRS_SITES_PKG dependencies on HZ_LOCATIONS

Line 37: HZ_LOCATIONS HZ

33: ,HZ.ADDRESS_STYLE
34: ,PN.BATCH_NAME
35: ,PN.SITE_ID
36: FROM
37: HZ_LOCATIONS HZ
38: ,RRS_SITES_B RRS
39: ,PN_LOCATIONS_ITF PN
40: WHERE HZ.LOCATION_ID = RRS.LOCATION_ID
41: AND PN.SITE_ID = RRS.SITE_ID

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;