APPS.BEN_OPI_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_opt_extra_info opi
         , ben_opt_f opt
     where opi.opt_extra_info_id = p_opt_extra_info_id
	and opt.opt_id = opi.opt_id
       and pbg.business_group_id = opt.business_group_id;

Line: 139

      select opt.active_inactive_flag
        from ben_opt_info_types opt
       where opt.information_type = code;

Line: 219

      select 'x'
      from ben_opt_f
      where opt_id = id;

Line: 296

     select multiple_occurences_flag
       from ben_opt_info_types
      where information_type = code;

Line: 301

     select 'x'
       from ben_opt_extra_info
      where information_type = code
        and opt_id = id;

Line: 373

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

Line: 727

End delete_validate;