APPS.PE_PEI_BUS SQL Statements

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

Line: 27

    select pbg.legislation_code
      from per_business_groups   pbg
          ,per_people_extra_info pei
          ,per_all_people_f      per
     where pei.person_extra_info_id = p_person_extra_info_id
       and per.person_id            = pei.person_id
       and pbg.business_group_id    = per.business_group_id;

Line: 116

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

Line: 160

end chk_non_updateable_args;

Line: 199

    SELECT 1
    FROM   per_all_people_f per                    -- Bug 4508101
    WHERE  per.person_id = p_person_id;

Line: 283

    SELECT pit.multiple_occurences_flag
          ,pit.active_inactive_flag
    FROM   per_people_info_types  pit
    WHERE  pit.information_type = p_information_type;

Line: 289

    SELECT 1
    FROM   per_people_extra_info pei
    WHERE  pei.information_type = p_information_type
    AND    pei.person_id        = p_person_id ;

Line: 687

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

Line: 728

End insert_validate;

Line: 733

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

Line: 753

  pe_pei_bus.chk_non_updateable_args (p_rec => p_rec);

Line: 764

End update_validate;

Line: 769

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

Line: 779

End delete_validate;