APPS.BEN_LRI_BUS SQL Statements

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

Line: 33

    select pbg.legislation_code
      from per_business_groups     pbg
         , ben_ler_extra_info lri
         , ben_ler_f ler
     where lri.ler_extra_info_id = p_ler_extra_info_id
	and ler.ler_id = lri.ler_id
       and pbg.business_group_id = ler.business_group_id;

Line: 139

      select ler.active_inactive_flag
        from ben_ler_info_types ler
       where ler.information_type = code;

Line: 219

      select 'x'
      from ben_ler_f
      where ler_id = id;

Line: 296

     select multiple_occurences_flag
       from ben_ler_info_types
      where information_type = code;

Line: 301

     select 'x'
       from ben_ler_extra_info
      where information_type = code
        and ler_id = id;

Line: 373

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

Line: 420

end chk_non_updateable_args;

Line: 424

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

Line: 578

End insert_validate;

Line: 583

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

Line: 592

  chk_non_updateable_args (p_rec => p_rec);

Line: 712

End update_validate;

Line: 717

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

Line: 727

End delete_validate;