APPS.PER_ES_LOCATION SQL Statements

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

Line: 43

PROCEDURE update_es_location (p_style        IN VARCHAR2
                             ,p_postal_code  IN VARCHAR2
                             ,p_region_2     IN VARCHAR2) is
--
BEGIN
  --
  -- Added for GSI Bug 5472781
  --
  IF hr_utility.chk_product_install('Oracle Human Resources', 'ES') THEN
    --
    per_es_location.check_es_location(p_style         => p_style
                                     ,p_postal_code   => p_postal_code
                                     ,p_region_2      => p_region_2);

Line: 59

END update_es_location;