APPS.HR_LOC_SHD SQL Statements

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

Line: 88

   cursor csr_select_row IS
     SELECT
       location_id,
       entered_by,
       location_code,
       timezone_code,
       address_line_1,
       address_line_2,
       address_line_3,
       bill_to_site_flag,
       country,
       description,
       designated_receiver_id,
       in_organization_flag,
       inactive_date,
       inventory_organization_id,
       office_site_flag,
       postal_code,
       receiving_site_flag,
       region_1,
       region_2,
       region_3,
       ship_to_location_id,
       ship_to_site_flag,
       derived_locale,
       style,
       tax_name,
       telephone_number_1,
       telephone_number_2,
       telephone_number_3,
       town_or_city,
       loc_information13,
       loc_information14,
       loc_information15,
       loc_information16,
       loc_information17,
       loc_information18,
       loc_information19,
       loc_information20,
       attribute_category,
       attribute1,
       attribute2,
       attribute3,
       attribute4,
       attribute5,
       attribute6,
       attribute7,
       attribute8,
       attribute9,
       attribute10,
       attribute11,
       attribute12,
       attribute13,
       attribute14,
       attribute15,
       attribute16,
       attribute17,
       attribute18,
       attribute19,
       attribute20,
       global_attribute_category,
       global_attribute1,
       global_attribute2,
       global_attribute3,
       global_attribute4,
       global_attribute5,
       global_attribute6,
       global_attribute7,
       global_attribute8,
       global_attribute9,
       global_attribute10,
       global_attribute11,
       global_attribute12,
       global_attribute13,
       global_attribute14,
       global_attribute15,
       global_attribute16,
       global_attribute17,
       global_attribute18,
       global_attribute19,
       global_attribute20,
       legal_address_flag,
       tp_header_id,
       ece_tp_location_code,
       object_version_number,
       business_group_id,
       geometry
       FROM hr_locations_all
       WHERE   location_id = p_location_id;

Line: 208

    OPEN csr_select_row;

Line: 209

    FETCH csr_select_row INTO g_old_rec;

Line: 210

    IF csr_select_row%notfound THEN
       CLOSE csr_select_row;

Line: 218

    CLOSE csr_select_row;

Line: 245

     SELECT
       location_id,
       entered_by,
       location_code,
       timezone_code,
       address_line_1,
       address_line_2,
       address_line_3,
       bill_to_site_flag,
       country,
       description,
       designated_receiver_id,
       in_organization_flag,
       inactive_date,
       inventory_organization_id,
       office_site_flag,
       postal_code,
       receiving_site_flag,
       region_1,
       region_2,
       region_3,
       ship_to_location_id,
       ship_to_site_flag,
       derived_locale,
       style,
       tax_name,
       telephone_number_1,
       telephone_number_2,
       telephone_number_3,
       town_or_city,
       loc_information13,
       loc_information14,
       loc_information15,
       loc_information16,
       loc_information17,
       loc_information18,
       loc_information19,
       loc_information20,
       attribute_category,
       attribute1,
       attribute2,
       attribute3,
       attribute4,
       attribute5,
       attribute6,
       attribute7,
       attribute8,
       attribute9,
       attribute10,
       attribute11,
       attribute12,
       attribute13,
       attribute14,
       attribute15,
       attribute16,
       attribute17,
       attribute18,
       attribute19,
       attribute20,
       global_attribute_category,
       global_attribute1,
       global_attribute2,
       global_attribute3,
       global_attribute4,
       global_attribute5,
       global_attribute6,
       global_attribute7,
       global_attribute8,
       global_attribute9,
       global_attribute10,
       global_attribute11,
       global_attribute12,
       global_attribute13,
       global_attribute14,
       global_attribute15,
       global_attribute16,
       global_attribute17,
       global_attribute18,
       global_attribute19,
       global_attribute20,
       legal_address_flag,
       tp_header_id,
       ece_tp_location_code,
       object_version_number,
       business_group_id,
       geometry
       FROM hr_locations_all
       WHERE   location_id = p_location_id
       FOR  UPDATE nowait;