APPS.PER_PRV_BUS SQL Statements

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

Line: 115

    select null
    from   per_events pev
    where  pev.event_id = p_event_id;

Line: 168

  select 1
  from per_all_people_f ppf
  where ppf.person_id=p_person_id
  and p_review_date between ppf.effective_start_date
  and ppf.effective_end_date
  and ppf.current_employee_flag='Y';

Line: 176

  select 1
  from per_performance_reviews prv
  where prv.person_id=p_person_id
  and   prv.review_date=p_review_date;

Line: 265

  select 1
  from per_all_people_f ppf
  where ppf.person_id=p_person_id
  and p_next_perf_review_date between ppf.effective_start_date
  and ppf.effective_end_date
  and ppf.current_employee_flag='Y';

Line: 332

  select perf_review_period,perf_review_period_frequency
  from per_all_assignments_f paf
  where paf.assignment_id=p_assignment_id
  and p_review_date between paf.effective_start_date
  and paf.effective_end_date;

Line: 673

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

Line: 712

End chk_non_updateable_args;

Line: 718

Procedure chk_delete_performance_review(p_performance_review_id in number) is
  --
  l_proc         varchar2(72) := g_package||'chk_delete_performance_review';

Line: 724

  select 1
  from per_pay_proposals ppp
  where ppp.performance_review_id=p_performance_review_id;

Line: 750

end chk_delete_performance_review;

Line: 755

Procedure insert_validate(p_rec in per_prv_shd.g_rec_type
                         ,p_next_review_date_warning out nocopy boolean ) is
--
  l_proc  varchar2(72) := g_package||'insert_validate';

Line: 810

End insert_validate;

Line: 815

Procedure update_validate(p_rec in per_prv_shd.g_rec_type
                         ,p_next_review_date_warning out nocopy boolean ) is
--
  l_proc  varchar2(72) := g_package||'update_validate';

Line: 832

  chk_non_updateable_args(
     p_rec            => p_rec);

Line: 874

End update_validate;

Line: 879

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

Line: 886

    chk_delete_performance_review (p_performance_review_id => p_rec.performance_review_id);

Line: 889

End delete_validate;

Line: 901

    select pbg.legislation_code
    from per_business_groups pbg
       , per_performance_reviews prv
       , per_all_people          per
    where prv.performance_review_id = p_performance_review_id
      and per.person_id = prv.person_id
      and per.business_group_id = pbg.business_group_id;