APPS.PER_PEA_BUS SQL Statements

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

Line: 59

    select   per.business_group_id
      from   per_people_f     per
     where   per.person_id   = p_person_id
       and   p_effective_date between per.effective_start_date
                                  and per.effective_end_date;

Line: 217

    select   pac.id_flex_num
    from     per_analysis_criteria     pac
    where    pac.analysis_criteria_id   = p_analysis_criteria_id;

Line: 328

select 'x'
from   per_person_analyses pa
      ,per_analysis_criteria ac
where  pa.analysis_criteria_id = p_analysis_criteria_id
and    pa.business_group_id + 0 = p_bg_id
and    pa.analysis_criteria_id = ac.analysis_criteria_id
and    ac.id_flex_num = p_id_flex_num
and    nvl(pa.date_to,hr_api.g_eot) =
       nvl(p_date_to,hr_api.g_eot)
and    pa.date_from = p_date_from
and    pa.person_id = p_person_id
and   (p_person_analysis_id is null
       or (p_person_analysis_id is not null
           and pa.person_analysis_id <> p_person_analysis_id));

Line: 378

      hr_utility.set_message(801,'HR_6012_ROW_INSERTED');

Line: 500

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

Line: 542

end check_non_updateable_args;

Line: 683

Procedure insert_validate
	(p_rec 			in per_pea_shd.g_rec_type,
         p_effective_date 	in date) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 772

End insert_validate;

Line: 777

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

Line: 805

  per_pea_bus.check_non_updateable_args(p_rec => p_rec);

Line: 861

End update_validate;

Line: 866

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

Line: 881

End delete_validate;

Line: 894

          select legislation_code
          from   per_business_groups  pbg,
                 per_person_analyses  ppa
          where  ppa.person_analysis_id = p_person_analysis_id
            and  pbg.business_group_id  = ppa.business_group_id;