APPS.PER_REQ_BUS SQL Statements

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

Line: 27

    select pbg.security_group_id
      from per_business_groups pbg
         , per_requisitions req
     where req.requisition_id = p_requisition_id
       and pbg.business_group_id = req.business_group_id;

Line: 87

    select pbg.legislation_code
      from per_business_groups pbg
         , per_requisitions req
     where req.requisition_id = p_requisition_id
       and pbg.business_group_id = req.business_group_id;

Line: 312

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

Line: 358

End chk_non_updateable_args;

Line: 397

  select null
    from per_requisitions
  where name = p_name;

Line: 558

  select person_id
    from per_all_people_f
  where person_id = p_person_id
  and p_date_from between effective_start_date and effective_end_date;

Line: 608

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

Line: 650

End insert_validate;

Line: 655

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

Line: 668

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 697

End update_validate;

Line: 702

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

Line: 714

End delete_validate;