APPS.ZX_HR_LOCATIONS_GNR_HOOK SQL Statements

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

Line: 60

    SELECT map_dtl.loc_component, map_dtl.geography_type
    BULK COLLECT INTO l_loc_component_tbl, l_geography_type
    FROM hz_geo_struct_map map, hz_geo_struct_map_dtl map_dtl, hz_address_usages usage, hz_address_usage_dtls usage_dtls
   WHERE map.loc_tbl_name = 'HR_LOCATIONS_ALL'
   AND  map.address_style = p_style
   AND  map.country_code = p_country
   AND  map.map_id = map_dtl.map_id
   AND  map_dtl.map_id = usage.map_id
   AND  usage.usage_code = 'TAX'
   AND  usage.usage_id = usage_dtls.usage_id
   AND  map_dtl.geography_type = usage_dtls.geography_type
   ORDER BY map_dtl.loc_seq_num;

Line: 73

   SELECT geography_id
   INTO l_country_geography_id
   FROM hz_geographies
   WHERE geography_type = 'COUNTRY'
   AND  geography_code = p_country;

Line: 97

             SELECT child_id
             INTO l_geography_id_tbl(i)
             FROM hz_hierarchy_nodes nodes, hz_geographies geo
             WHERE parent_id = l_geography_id_tbl(i-1)
             AND  parent_object_type = l_geography_type(i-1)
             AND  child_object_type = l_geography_type(i)
             AND  nodes.child_id = geo.geography_id
             AND  UPPER(geo.geography_name) = UPPER(l_geography_value)
             AND  nodes.level_number = 1;

Line: 170

PROCEDURE update_gnr (p_location_id IN NUMBER,
	              p_country     IN VARCHAR2,
                      p_region_1    IN VARCHAR2,
                      p_region_2    IN VARCHAR2,
                      p_region_3    IN VARCHAR2,
                      p_town_or_city  IN VARCHAR2,
                      p_postal_code IN VARCHAR2,
                      p_style_o     IN VARCHAR2,
                      p_country_o   IN VARCHAR2,
                      p_region_1_o  IN VARCHAR2,
                      p_region_2_o  IN VARCHAR2,
                      p_region_3_o  IN VARCHAR2,
                      p_town_or_city_o IN VARCHAR2,
	              p_postal_code_o  IN VARCHAR2) IS
  p_init_msg_list VARCHAR2(1);

Line: 217

END update_gnr;