APPS.HZ_GNR_GEN_PKG dependencies on HZ_GEO_STRUCT_MAP

Line 2530: FROM hz_geo_struct_map

2526: l_usage_dtls_tbl HZ_GNR_UTIL_PKG.USAGE_DTLS_TBL_TYPE;
2527:
2528: CURSOR c_map(p_map_id IN NUMBER) IS
2529: SELECT MAP_ID,COUNTRY_CODE,LOC_TBL_NAME,ADDRESS_STYLE
2530: FROM hz_geo_struct_map
2531: WHERE map_id = p_map_id;
2532:
2533: CURSOR c_map_dtls(p_map_id IN NUMBER) IS
2534: SELECT MAP_ID,LOC_SEQ_NUM,LOC_COMPONENT,GEOGRAPHY_TYPE,GEO_ELEMENT_COL

Line 2535: FROM hz_geo_struct_map_dtl

2531: WHERE map_id = p_map_id;
2532:
2533: CURSOR c_map_dtls(p_map_id IN NUMBER) IS
2534: SELECT MAP_ID,LOC_SEQ_NUM,LOC_COMPONENT,GEOGRAPHY_TYPE,GEO_ELEMENT_COL
2535: FROM hz_geo_struct_map_dtl
2536: WHERE map_id = p_map_id
2537: ORDER BY LOC_SEQ_NUM;
2538:
2539: CURSOR c_usage(p_map_id IN NUMBER) IS