APPS.PER_BPR_BUS SQL Statements

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

Line: 27

    select inf.org_information14
      from hr_organization_information inf
         , per_bf_payroll_runs bpr
     where bpr.payroll_run_id = p_payroll_run_id
       and inf.organization_id   = bpr.business_group_id
       and inf.org_information_context || '' = 'Business Group Information';

Line: 84

    select pbg.legislation_code
      from per_business_groups pbg
         , per_bf_payroll_runs bpr
     where bpr.payroll_run_id = p_payroll_run_id
       and pbg.business_group_id = bpr.business_group_id;

Line: 346

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

Line: 392

End chk_non_updateable_args;

Line: 422

  SELECT 1
  FROM per_bf_payroll_runs
  WHERE(  (p_payroll_run_id IS NULL)
       or (payroll_run_id <> p_payroll_run_id))
    AND payroll_identifier = p_payroll_identifier
    AND business_group_id  = p_business_group_id ;

Line: 705

  select 'Y'
  from per_bf_processed_assignments bpa
  where bpa.payroll_run_id = p_payroll_run_id;

Line: 728

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

Line: 768

End insert_validate;

Line: 773

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

Line: 812

  chk_non_updateable_args(p_rec => p_rec);

Line: 819

End update_validate;

Line: 824

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

Line: 836

End delete_validate;