APPS.HZ_GEO_GET_PUB dependencies on HZ_GEOGRAPHY_TYPES_B

Line 15: l_ref_geo_type hz_geography_types_b.geography_type%TYPE;

11: x_return_status OUT NOCOPY VARCHAR2,
12: x_msg_count OUT NOCOPY NUMBER,
13: x_msg_data OUT NOCOPY VARCHAR2) IS
14:
15: l_ref_geo_type hz_geography_types_b.geography_type%TYPE;
16: l_count NUMBER;
17: l_gnr_count NUMBER;
18: l_geography_id NUMBER;
19: l_postal_code VARCHAR2(360);

Line 21: l_geography_use hz_geography_types_b.geography_use%TYPE;

17: l_gnr_count NUMBER;
18: l_geography_id NUMBER;
19: l_postal_code VARCHAR2(360);
20: l_postal_code_range_flag VARCHAR2(1);
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

Line 63: FROM hz_geography_types_b

59:
60: -- Bug 6842648 Perf fix to query
61: SELECT count(1)
62: INTO l_count
63: FROM hz_geography_types_b
64: WHERE geography_type = p_zone_type
65: AND geography_use <> 'MASTER_REF'
66: AND rownum = 1;
67:

Line 181: FROM hz_geography_types_b

177:
178: IF l_zone_id IS NOT NULL THEN
179: SELECT postal_code_range_flag, geography_use
180: INTO l_postal_code_range_flag, l_geography_use
181: FROM hz_geography_types_b
182: WHERE geography_type = p_zone_type;
183:
184:
185: -- Postal code range flag is applicable only for eTax