APPS.HR_LOC_BUS SQL Statements

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

Line: 37

    SELECT business_group_id
      FROM hr_locations_all
     WHERE location_id = p_location_id;

Line: 50

    SELECT legislation_code
      FROM per_business_groups
     WHERE business_group_id = l_business_group_id;

Line: 182

     SELECT NULL
     FROM hr_locations_all
       WHERE location_id = p_ship_to_location_id
         AND ship_to_site_flag = 'Y'
         AND nvl(inactive_date, hr_api.g_eot) >= p_effective_date
         AND (  p_business_group_id IS NULL
                OR nvl(business_group_id, p_business_group_id)
                  = p_business_group_id );

Line: 404

     SELECT NULL
     FROM per_all_people_f
       WHERE person_id = p_designated_receiver_id
       AND employee_number IS NOT NULL
       AND p_effective_date BETWEEN effective_start_date AND effective_end_date
       AND ( p_business_group_id IS NULL
             OR p_business_group_id = business_group_id +0);

Line: 572

           ' SELECT NULL
              FROM INV_ORGANIZATION_NAME_V
              WHERE organization_id = :pOrgId', DBMS_SQL.Native );

Line: 653

     SELECT NULL
        FROM ap_tax_codes
        WHERE nvl(inactive_date, hr_api.g_eot ) >= p_effective_date
          AND name = p_tax_name;

Line: 739

     SELECT NULL
        FROM fnd_descr_flex_contexts_vl vl
        WHERE vl.descriptive_flexfield_name ='Address Location'
           AND vl.enabled_flag = 'Y'
	   AND vl.application_id = 800
           AND vl.descriptive_flex_context_code = p_style;

Line: 817

     SELECT NULL
        FROM fnd_timezones_vl vl
        WHERE vl.timezone_code = p_timezone_code
          AND vl.enabled_flag = 'Y';

Line: 905

   SELECT NULL
     FROM  per_all_assignments_f
     WHERE location_id = p_location_id;

Line: 910

   SELECT NULL
     FROM  pay_wc_funds
     WHERE location_id = p_location_id;

Line: 915

   SELECT NULL
     FROM  per_events
     WHERE location_id = p_location_id;

Line: 920

   SELECT NULL
     FROM  per_all_vacancies
     WHERE location_id = p_location_id;

Line: 925

   SELECT NULL
     FROM  hr_all_organization_units
     WHERE location_id = p_location_id;

Line: 930

   SELECT NULL
     FROM  hr_all_positions_f
     WHERE location_id = p_location_id;

Line: 935

   SELECT NULL
     FROM  pay_element_links_f
     WHERE location_id = p_location_id;

Line: 940

   SELECT NULL
     FROM  per_salary_survey_mappings
     WHERE location_id = p_location_id;

Line: 945

   SELECT NULL
     FROM  hr_location_extra_info
     WHERE location_id = p_location_id;

Line: 950

   SELECT NULL
     FROM  per_us_inval_locations
     WHERE location_id = p_location_id;

Line: 1110

PROCEDURE chk_non_updateable_args(p_rec IN hr_loc_shd.g_rec_type) IS
--
  l_proc     VARCHAR2(72) := g_package||'chk_non_updateable_args';

Line: 1147

END chk_non_updateable_args;

Line: 1496

PROCEDURE insert_validate
  (  p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
     p_effective_date IN DATE,
     p_operating_unit_id IN NUMBER)
IS
--
   l_proc  VARCHAR2(72) := g_package||'insert_validate';

Line: 1619

END insert_validate;

Line: 1624

PROCEDURE update_validate
 (  p_rec IN OUT NOCOPY hr_loc_shd.g_rec_type,
    p_effective_date IN DATE,
    p_operating_unit_id IN NUMBER)
IS
--
   l_proc  VARCHAR2(72) := g_package||'update_validate';

Line: 1646

  chk_non_updateable_args(p_rec => p_rec);

Line: 1743

END update_validate;

Line: 1749

PROCEDURE delete_validate
  (p_rec          IN    hr_loc_shd.g_rec_type
 ) IS

--
  l_proc  VARCHAR2(72) := g_package||'delete_validate';

Line: 1771

END delete_validate;