APPS.HZ_GNR_GEN_PKG dependencies on HZ_ADDRESS_USAGES
Line 2541: FROM hz_address_usages
2537: ORDER BY LOC_SEQ_NUM;
2538:
2539: CURSOR c_usage(p_map_id IN NUMBER) IS
2540: SELECT MAP_ID,USAGE_ID,USAGE_CODE 2541: FROM hz_address_usages 2542: WHERE map_id = p_map_id
2543: AND status_flag = 'A'
2544: ORDER BY usage_id;
2545: