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 80: FROM hz_geography_types_b

76:
77: -- Bug 6842648 Perf fix to query
78: SELECT count(1)
79: INTO l_count
80: FROM hz_geography_types_b
81: WHERE geography_type = p_zone_type
82: AND geography_use <> 'MASTER_REF'
83: AND rownum = 1;
84:

Line 233: FROM hz_geography_types_b

229:
230: IF l_zone_id IS NOT NULL THEN
231: SELECT postal_code_range_flag, geography_use
232: INTO l_postal_code_range_flag, l_geography_use
233: FROM hz_geography_types_b
234: WHERE geography_type = p_zone_type;
235:
236: IF fnd_log.level_statement>=fnd_log.g_current_runtime_level THEN
237: hz_utility_v2pub.debug(p_prefix=>l_debug_prefix,p_message=>' For Geography Type '||p_zone_type