APPS.HZ_GNR_PKG dependencies on HZ_GEO_STRUCT_MAP

Line 62: FROM hz_geo_struct_map

58: FUNCTION get_map_id(p_country in varchar2,p_loc_table in varchar2,p_address_style in varchar2) RETURN NUMBER IS
59: l_map_id number;
60: CURSOR c_map IS
61: SELECT MAP_ID
62: FROM hz_geo_struct_map
63: WHERE COUNTRY_CODE = p_country
64: AND LOC_TBL_NAME = p_loc_table
65: AND NVL(ADDRESS_STYLE,'X_NOSTYLE_X') = NVL(p_address_style,'X_NOSTYLE_X');
66:

Line 69: FROM hz_geo_struct_map

65: AND NVL(ADDRESS_STYLE,'X_NOSTYLE_X') = NVL(p_address_style,'X_NOSTYLE_X');
66:
67: CURSOR c_style_null_map IS
68: SELECT MAP_ID
69: FROM hz_geo_struct_map
70: WHERE COUNTRY_CODE = p_country
71: AND LOC_TBL_NAME = p_loc_table
72: AND ADDRESS_STYLE IS NULL;
73: BEGIN

Line 852: FROM hz_geo_struct_map

848: l_map_exist VARCHAR2(10);
849:
850: CURSOR c_r12_upg_map_cnt IS
851: SELECT DISTINCT country_code
852: FROM hz_geo_struct_map
853: WHERE loc_tbl_name = 'HZ_LOCATIONS';
854:
855: TYPE mapped_country_tbl_type IS TABLE OF VARCHAR2(10) INDEX BY BINARY_INTEGER;
856: mapped_country_list mapped_country_tbl_type;