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: 661

     SELECT NULL
     FROM zx_input_classifications_v
     WHERE nvl(end_date_active, hr_api.g_eot ) >= p_effective_date
     AND lookup_type = 'ZX_INPUT_CLASSIFICATIONS'
     AND lookup_code = p_tax_name ;

Line: 750

     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: 828

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

Line: 916

   SELECT NULL
     FROM  per_all_assignments_f
     WHERE location_id = p_location_id;

Line: 921

   SELECT NULL
     FROM  pay_wc_funds
     WHERE location_id = p_location_id;

Line: 926

   SELECT NULL
     FROM  per_events
     WHERE location_id = p_location_id;

Line: 931

   SELECT NULL
     FROM  per_all_vacancies
     WHERE location_id = p_location_id;

Line: 936

   SELECT NULL
     FROM  hr_all_organization_units
     WHERE location_id = p_location_id;

Line: 941

   SELECT NULL
     FROM  hr_all_positions_f
     WHERE location_id = p_location_id;

Line: 946

   SELECT NULL
     FROM  pay_element_links_f
     WHERE location_id = p_location_id;

Line: 951

   SELECT NULL
     FROM  per_salary_survey_mappings
     WHERE location_id = p_location_id;

Line: 956

   SELECT NULL
     FROM  hr_location_extra_info
     WHERE location_id = p_location_id;

Line: 961

   SELECT NULL
     FROM  per_us_inval_locations
     WHERE location_id = p_location_id;

Line: 967

     select NULL
     from HR_LOCATIONS_ALL
     where location_id = p_location_id
     and LEGAL_ADDRESS_FLAG ='Y';

Line: 1144

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: 1181

END chk_non_updateable_args;

Line: 1530

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: 1653

END insert_validate;

Line: 1658

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: 1680

  chk_non_updateable_args(p_rec => p_rec);

Line: 1777

END update_validate;

Line: 1783

PROCEDURE delete_validate
  (p_rec          IN    hr_loc_shd.g_rec_type
 ) IS

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

Line: 1805

END delete_validate;