APPS.HZ_GEO_GET_PUB dependencies on HZ_RELATIONSHIP_TYPES

Line 25: FROM hz_relationship_types

21: l_geography_use hz_geography_types_b.geography_use%TYPE;
22:
23: CURSOR included_geo_types(p_zone_type IN VARCHAR2) IS
24: SELECT object_type
25: FROM hz_relationship_types
26: WHERE subject_type = p_zone_type
27: AND status = 'A'
28: AND relationship_type = 'TAX';
29:

Line 82: FROM hz_relationship_types

78: BEGIN
79: -- Bug 6842648 Perf fix to query
80: SELECT count(1)
81: INTO l_count
82: FROM hz_relationship_types
83: WHERE subject_type = p_zone_type
84: AND status = 'A'
85: AND rownum = 1;
86: END;