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 99: FROM hz_relationship_types

95: BEGIN
96: -- Bug 6842648 Perf fix to query
97: SELECT count(1)
98: INTO l_count
99: FROM hz_relationship_types
100: WHERE subject_type = p_zone_type
101: AND status = 'A'
102: AND rownum = 1;
103: END;