DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 2748: FROM HZ_RELATIONSHIP_TYPES

2744: IF l_limited_by_geography_id IS NULL THEN
2745: -- check if there exists a relationship_type for this geography_type and
2746: -- included_geography_type
2747: SELECT count(*) INTO l_COUNT
2748: FROM HZ_RELATIONSHIP_TYPES
2749: WHERE subject_type = l_zone_type
2750: AND object_type= l_incl_geo_type
2751: AND forward_rel_code = 'PARENT_OF'
2752: AND backward_rel_code = 'CHILD_OF'