DBA Data[Home] [Help]

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