APPS.HZ_GNR_GEN_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 389

    SELECT GEOGRAPHY_ID
    INTO   g_country_geo_id
    FROM   HZ_GEOGRAPHIES
    WHERE  COUNTRY_CODE = G_MAP_REC.COUNTRY_CODE
    AND    GEOGRAPHY_TYPE = 'COUNTRY';

Line: 941

      l('      SELECT '||L_MDU_TBL(i).LOC_COMPONENT);

Line: 1844

        l('    -- This change is to update COUNTRY column in locations table with COUNTRY_CODE ');

Line: 2554

    SELECT MAP_ID,COUNTRY_CODE,LOC_TBL_NAME,ADDRESS_STYLE
    FROM   hz_geo_struct_map
    WHERE  map_id = p_map_id;

Line: 2559

    SELECT MAP_ID,LOC_SEQ_NUM,LOC_COMPONENT,GEOGRAPHY_TYPE,GEO_ELEMENT_COL
    FROM   hz_geo_struct_map_dtl
    WHERE  map_id = p_map_id
    ORDER  BY LOC_SEQ_NUM;

Line: 2565

    SELECT MAP_ID,USAGE_ID,USAGE_CODE
    FROM   hz_address_usages
    WHERE  map_id = p_map_id
    AND    status_flag = 'A'
    ORDER BY usage_id;

Line: 2572

    SELECT udtl.USAGE_ID,udtl.GEOGRAPHY_TYPE
    FROM   hz_address_usage_dtls udtl
    WHERE  USAGE_ID = p_usage_id;