APPS.HR_LEI_BUS SQL Statements

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

Line: 49

      select 'x'
        from hr_locations
       where location_id = p_location_id and location_use = 'HR';

Line: 113

Procedure chk_non_updateable_args(p_rec in hr_lei_shd.g_rec_type) is
--
  l_proc        varchar2(72) := g_package||'chk_non_updateable_args';

Line: 157

end chk_non_updateable_args;

Line: 203

	SELECT	lit.multiple_occurences_flag
			,lit.active_inactive_flag
	FROM		hr_location_info_types	lit
	WHERE		lit.information_type 		= p_information_type
	;

Line: 302

	SELECT	'x'
	FROM		hr_location_extra_info	lei
	WHERE		lei.information_type 		= p_information_type
	AND		lei.location_id			= p_location_id ;

Line: 674

Procedure insert_validate(p_rec in hr_lei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 683

     select hoi.org_information14, hoi.org_information9
       from hr_organization_information hoi
            , hr_locations_all loc
      where loc.location_id = p_rec.location_id
        and hoi.organization_id = nvl(loc.business_group_id,0)
        and hoi.org_information_context||'' = 'Business Group Information';

Line: 693

 select hoi.org_information14, hoi.org_information9
       from hr_organization_information hoi
            , hr_locations_all loc
      where loc.location_id =  p_rec.location_id
       and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))
        and hoi.org_information_context||'' = 'Business Group Information';

Line: 753

End insert_validate;

Line: 758

Procedure update_validate(p_rec in hr_lei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 765

     select hoi.org_information14, hoi.org_information9
       from hr_organization_information hoi
            , hr_locations_all loc
      where loc.location_id = p_rec.location_id
        and hoi.organization_id = nvl(loc.business_group_id,0)
        and hoi.org_information_context||'' = 'Business Group Information';

Line: 775

 select hoi.org_information14, hoi.org_information9
       from hr_organization_information hoi
            , hr_locations_all loc
      where loc.location_id =  p_rec.location_id
       and hoi.organization_id = nvl(loc.business_group_id,nvl(hr_general.get_business_group_id, -99))
       and hoi.org_information_context||'' = 'Business Group Information';

Line: 811

  chk_non_updateable_args (p_rec => p_rec);

Line: 826

End update_validate;

Line: 831

Procedure delete_validate(p_rec in hr_lei_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 841

End delete_validate;