APPS.HZ_GNR_PUB SQL Statements

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

Line: 26

    SELECT
      LOCATION_ID,
      ADDRESS_STYLE,
      COUNTRY,
      STATE,
      PROVINCE,
      COUNTY,
      CITY,
      POSTAL_CODE,
      POSTAL_PLUS4_CODE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10
    FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;

Line: 55

        HZ_GNR_PKG.delete_gnr(
                 p_locId       => p_location_id,
                 p_locTbl      => upper(p_location_table_name),
                 x_status      => l_return_status
                 );

Line: 68

        HZ_GNR_PKG.delete_gnr(
                 p_locId       => p_location_id,
                 p_locTbl      => upper(p_location_table_name),
                 x_status      => l_return_status
                 );

Line: 122

    select ADDR_VAL_LEVEL
    from hz_geo_structure_levels
    where PARENT_GEOGRAPHY_TYPE = 'COUNTRY'
    and  COUNTRY_CODE = p_country_code;

Line: 157

    SELECT MAP_STATUS
    FROM   HZ_GEO_NAME_REFERENCE_LOG
    WHERE  LOCATION_TABLE_NAME = p_location_table_name
    AND    LOCATION_ID = p_location_id
    AND    USAGE_CODE = p_usage_code;

Line: 188

    SELECT
      LOCATION_ID,
      ADDRESS_STYLE,
      COUNTRY,
      STATE,
      PROVINCE,
      COUNTY,
      CITY,
      POSTAL_CODE,
      POSTAL_PLUS4_CODE,
      ATTRIBUTE1,
      ATTRIBUTE2,
      ATTRIBUTE3,
      ATTRIBUTE4,
      ATTRIBUTE5,
      ATTRIBUTE6,
      ATTRIBUTE7,
      ATTRIBUTE8,
      ATTRIBUTE9,
      ATTRIBUTE10
    FROM HZ_LOCATIONS WHERE LOCATION_ID = p_location_id;