APPS.PE_JEI_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
         , per_job_extra_info jei
         , per_jobs pj
     where jei.job_extra_info_id = p_job_extra_info_id
	and jei.job_id = pj.job_id
       and pbg.business_group_id = pj.business_group_id;

Line: 139

      select jeit.active_inactive_flag
        from per_job_info_types jeit
       where jeit.information_type = code;

Line: 223

      select 'x'
      from per_jobs
      where job_id = id;

Line: 301

     select multiple_occurences_flag
       from per_job_info_types
      where information_type = code;

Line: 306

     select 'x'
       from per_job_extra_info
      where information_type = code
        and job_id = id;

Line: 378

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

Line: 425

end chk_non_updateable_args;

Line: 429

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

Line: 583

End insert_validate;

Line: 588

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

Line: 597

  chk_non_updateable_args (p_rec => p_rec);

Line: 730

End update_validate;

Line: 735

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

Line: 745

End delete_validate;