DBA Data[Home] [Help]

APPS.HZ_GEOGRAPHY_PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 2761: FROM HZ_RELATIONSHIP_TYPES

2757: IF l_limited_by_geography_id IS NULL THEN
2758: -- check if there exists a relationship_type for this geography_type and
2759: -- included_geography_type
2760: SELECT count(*) INTO l_COUNT
2761: FROM HZ_RELATIONSHIP_TYPES
2762: WHERE subject_type = l_zone_type
2763: AND object_type= l_incl_geo_type
2764: AND forward_rel_code = 'PARENT_OF'
2765: AND backward_rel_code = 'CHILD_OF'