APPS.PQH_REI_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id
      from per_business_groups pbg
         , pqh_role_extra_info rei
         , pqh_roles  rls
      where rei.role_extra_info_id = p_role_extra_info_id
      and rei.role_id = rls.role_id
      and pbg.business_group_id = rls.business_group_id;

Line: 94

    select pbg.legislation_code
      from per_business_groups     pbg
         , pqh_role_extra_info rei
         , pqh_roles  rls
     where rei.role_extra_info_id = p_role_extra_info_id
     and   rei.role_id = rls.role_id
     and   pbg.business_group_id = rls.business_group_id;

Line: 198

      select reit.active_inactive_flag
        from pqh_role_info_types reit
       where reit.information_type = code;

Line: 278

         select 'x'
         from pqh_roles
         where role_id = id;

Line: 353

     select multiple_occurences_flag
       from pqh_role_info_types
      where information_type = code;

Line: 358

     select 'x'
       from pqh_role_extra_info
      where information_type = code
        and role_id = id;

Line: 431

Procedure chk_non_updateable_args (p_rec in pqh_rei_shd.g_rec_type) is

--
  l_proc		varchar2(72) := g_package||'chk_non_updateable_args';

Line: 479

end chk_non_updateable_args;

Line: 841

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

Line: 875

End insert_validate;

Line: 880

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

Line: 889

  chk_non_updateable_args
    (p_rec                       => p_rec
    );

Line: 901

End update_validate;

Line: 906

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

Line: 918

End delete_validate;