APPS.HZ_GEOGRAPHY_VALIDATE_PVT dependencies on HZ_RELATIONSHIPS
Line 293: FROM HZ_RELATIONSHIPS
289: IF p_create_update_flag = 'C' THEN
290:
291: -- check whether geography_id is unique within parent_geography_id
292: SELECT count(*) INTO l_count 293: FROM HZ_RELATIONSHIPS 294: WHERE subject_id=p_master_relation_rec.parent_geography_id
295: AND object_id = p_master_relation_rec.geography_id
296: AND subject_type = l_parent_geography_type
297: AND object_type = l_geography_type