APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_GEOGRAPHY_IDENTIFIERS

Line 424: FROM HZ_GEOGRAPHY_IDENTIFIERS

420: /* If p_create_update_flag = 'C' THEN
421: -- check the uniqueness for the combination of geography_id,identifier_type,
422: -- identifier_subtype,identifier_value and language_code
423: SELECT count(*) INTO l_count
424: FROM HZ_GEOGRAPHY_IDENTIFIERS
425: WHERE geography_id=p_geo_identifier_rec.geography_id
426: AND identifier_type=p_geo_identifier_rec.identifier_type
427: AND identifier_subtype=p_geo_identifier_rec.identifier_subtype
428: AND identifier_value=p_geo_identifier_rec.identifier_value

Line 459: FROM HZ_GEOGRAPHY_IDENTIFIERS

455: IF p_geo_identifier_rec.identifier_type='NAME' THEN
456: -- check if name is unique for a geography_id and identifier type, with in that language_code
457: -- identifier type check added in WHERE clause by NSINGHAI on 25-Aug-2005 for Bug 4549821
458: SELECT count(*) INTO l_count
459: FROM HZ_GEOGRAPHY_IDENTIFIERS
460: WHERE geography_id=p_geo_identifier_rec.geography_id
461: AND language_code = UPPER(p_geo_identifier_rec.language_code)
462: AND UPPER(identifier_value) = UPPER(p_geo_identifier_rec.identifier_value)
463: AND identifier_type = p_geo_identifier_rec.identifier_type

Line 478: FROM hz_geography_identifiers

474:
475: IF p_create_update_flag = 'U' THEN
476: --check if the row exists
477: SELECT count(*) INTO l_count
478: FROM hz_geography_identifiers
479: WHERE geography_id = p_geo_identifier_rec.geography_id
480: AND identifier_type = p_geo_identifier_rec.identifier_type
481: AND identifier_subtype = p_geo_identifier_rec.identifier_subtype
482: AND identifier_value = p_geo_identifier_rec.identifier_value