APPS.ZX_GEO_JUR_MIGR_PKG dependencies on HZ_GEOGRAPHIES

Line 29: FROM hz_geographies

25: --
26: BEGIN
27: SELECT geography_id
28: INTO x_zone_geography_id
29: FROM hz_geographies
30: WHERE geography_type = p_zone_type
31: AND geography_name = l_zone_name;
32: --
33: l_zone_exists := 'TRUE';

Line 146: ar_system_parameters_all sys, hz_geographies geo

142: BULK COLLECT INTO
143: l_location_structure_id_tbl, l_country_code_tbl,
144: l_segment_attribute_type_tbl, l_geography_id_tbl
145: FROM fnd_id_flex_structures struct, fnd_id_flex_segments_vl seg, fnd_segment_attribute_values attr,
146: ar_system_parameters_all sys, hz_geographies geo
147: WHERE struct.application_id = seg.application_id
148: AND struct.id_flex_code = seg.id_flex_code
149: AND struct.id_flex_num = seg.id_flex_num
150: AND struct.freeze_flex_definition_flag = 'Y'