APPS.HR_RU_LOCATION_HOOK SQL Statements

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

Line: 33

   PROCEDURE update_ru_location (
      p_location_id         IN   NUMBER,
      p_style               IN   VARCHAR2,
      p_loc_information13   IN   VARCHAR2,
      p_postal_code         IN   VARCHAR2
   )
   AS
      l_proc       CONSTANT VARCHAR2 (72)
                                         := g_package || 'UPDATE_RU_LOCATION';

Line: 48

         SELECT style, loc_information13, postal_code
           FROM hr_locations_all
          WHERE location_id = p_id;

Line: 100

   END update_ru_location;