APPS.HZ_GEO_STRUCT_MAP_PUB dependencies on FND_TERRITORIES

Line 65: FROM fnd_territories

61:
62: BEGIN
63: SELECT address_style
64: INTO l_context
65: FROM fnd_territories
66: WHERE territory_code = p_territory_code
67: AND l_application_id = 222
68: AND address_style = p_context ;
69:

Line 261: -- country should exist in fnd_territories

257: FND_MSG_PUB.ADD;
258: RAISE FND_API.G_EXC_ERROR;
259: END IF;
260:
261: -- country should exist in fnd_territories
262:
263: BEGIN
264: SELECT territory_code
265: INTO l_country

Line 266: FROM fnd_territories

262:
263: BEGIN
264: SELECT territory_code
265: INTO l_country
266: FROM fnd_territories
267: WHERE territory_code = UPPER(p_geo_struct_map_rec.country_code);
268:
269: EXCEPTION WHEN NO_DATA_FOUND THEN
270: x_return_status := FND_API.G_RET_STS_ERROR;