APPS.BEN_ABI_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_abr_extra_info abi
         , ben_acty_base_rt_f abr
     where abi.abr_extra_info_id = p_abr_extra_info_id
	and abr.acty_base_rt_id = abi.acty_base_rt_id
       and pbg.business_group_id = abr.business_group_id;

Line: 139

      select abr.active_inactive_flag
        from ben_abr_info_types abr
       where abr.information_type = code;

Line: 219

      select 'x'
      from ben_acty_base_rt_f
      where acty_base_rt_id = id;

Line: 296

     select multiple_occurences_flag
       from ben_abr_info_types
      where information_type = code;

Line: 301

     select 'x'
       from ben_abr_extra_info
      where information_type = code
        and acty_base_rt_id = id;

Line: 373

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

Line: 727

End delete_validate;