APPS.BEN_ELI_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_elp_extra_info eli
         , ben_eligy_prfl_f elp
     where eli.elp_extra_info_id = p_elp_extra_info_id
	and elp.eligy_prfl_id = eli.eligy_prfl_id
       and pbg.business_group_id = elp.business_group_id;

Line: 139

      select elp.active_inactive_flag
        from ben_elp_info_types elp
       where elp.information_type = code;

Line: 219

      select 'x'
      from ben_eligy_prfl_f
      where eligy_prfl_id = id;

Line: 296

     select multiple_occurences_flag
       from ben_elp_info_types
      where information_type = code;

Line: 301

     select 'x'
       from ben_elp_extra_info
      where information_type = code
        and eligy_prfl_id = id;

Line: 373

Procedure chk_non_updateable_args (p_rec in ben_eli_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_eli_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_eli_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_eli_shd.g_rec_type) is
--
  l_proc  varchar2(72) := g_package||'delete_validate';

Line: 727

End delete_validate;