DBA Data[Home] [Help]

APPS.HZ_GNR_PKG dependencies on FND_TERRITORIES

Line 307: -- Validate Country Code parameter from FND_TERRITORIES

303: RAISE FND_API.G_EXC_ERROR;
304: END IF;
305: END IF;
306:
307: -- Validate Country Code parameter from FND_TERRITORIES
308: IF (p_country_code IS NOT NULL) THEN
309: SELECT COUNT(*)
310: INTO l_country_code_count
311: FROM fnd_territories

Line 311: FROM fnd_territories

307: -- Validate Country Code parameter from FND_TERRITORIES
308: IF (p_country_code IS NOT NULL) THEN
309: SELECT COUNT(*)
310: INTO l_country_code_count
311: FROM fnd_territories
312: WHERE territory_code = p_country_code
313: AND obsolete_flag = 'N';
314:
315: IF (l_country_code_count = 0) THEN