APPS.HZ_GEO_STRUCTURE_VALIDATE_PVT dependencies on HZ_GEO_STRUCTURE_LEVELS

Line 385: FROM hz_geo_structure_levels

381: IF p_create_update_flag = 'C' THEN
382: BEGIN
383:
384: SELECT count(*) INTO l_geo_count
385: FROM hz_geo_structure_levels
386: WHERE geography_id = p_geo_structure_rec.geography_id
387: AND geography_type = p_geo_structure_rec.geography_type;
388:
389: IF l_geo_count > 0 THEN

Line 398: FROM hz_geo_structure_levels

394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: SELECT count(*) INTO l_pgeo_count
398: FROM hz_geo_structure_levels
399: WHERE geography_id = p_geo_structure_rec.geography_id
400: AND parent_geography_type = p_geo_structure_rec.parent_geography_type;
401:
402: IF l_pgeo_count > 0 THEN