APPS.HR_LOT_BUS SQL Statements

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

Line: 70

    select null
      from hr_locations_all loc, hr_locations_all_tl lot
      where lot.location_id <> nvl(p_location_id, -99)
        and lot.language = p_language
        and upper(lot.location_code) = upper(p_location_code)
        and lot.location_id = loc.location_id
        and ( loc.business_group_id +0 is null
           or p_business_group_id is null
           or loc.business_group_id +0 = p_business_group_id );

Line: 180

Procedure insert_validate ( p_rec                in hr_lot_shd.g_rec_type,
			    p_business_group_id  in number)
is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 208

End insert_validate;

Line: 213

Procedure update_validate( p_rec                in hr_lot_shd.g_rec_type,
			   p_business_group_id  in number )
is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 239

End update_validate;

Line: 244

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

Line: 254

End delete_validate;