APPS.HZ_GNR_UTIL_PKG dependencies on HZ_GEO_STRUCT_MAP_DTL

Line 626: l_mapdtl hz_geo_struct_map_dtl%ROWTYPE;

622: -- temp variable declaration
623: -- l_cntry varchar2(2);
624: l_addrstyle varchar2(30);
625: l_sql1 varchar2(1000);
626: l_mapdtl hz_geo_struct_map_dtl%ROWTYPE;
627: i number;
628: l_eflag varchar2(2);
629: l_debug_prefix VARCHAR2(30) := '';
630:

Line 634: FROM hz_geo_struct_map_dtl

630:
631: CURSOR c1 (cp_map_id number) IS
632: SELECT loc_seq_num, loc_component,
633: geography_type, geo_element_col
634: FROM hz_geo_struct_map_dtl
635: WHERE map_id = cp_map_id
636: ORDER BY loc_seq_num ASC;
637:
638: BEGIN