APPS.PER_PPB_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id
      from per_business_groups pbg
         , per_pay_bases ppb
     where ppb.pay_basis_id = p_pay_basis_id
       and pbg.business_group_id = ppb.business_group_id;

Line: 92

    select pbg.legislation_code
      from per_business_groups pbg
         , per_pay_bases ppb
     where ppb.pay_basis_id = p_pay_basis_id
       and pbg.business_group_id = ppb.business_group_id;

Line: 264

  select 'x'
  from pay_rates
  where rate_id = p_rate_id;

Line: 330

         select 'Y'
         from  per_pay_bases ppb
         where upper(ppb.name)     = upper(p_name)
         and ppb.business_group_id = p_business_group_id
--4154786
         and  ppb.pay_basis_id <> p_pay_basis_id
         ;

Line: 635

select 'x'
from  pay_input_values_f piv,
      pay_element_types_f pet,
      pay_element_classifications pec
where piv.input_value_id = p_input_value_id
  and piv.element_type_id = pet.element_type_id
  and sysdate between pet.effective_start_date
  	          and pet.effective_end_date
  and (pet.business_group_id = p_business_group_id
      or  pet.business_group_id is null
      and pet.legislation_code = p_legislation_code)
  and pet.processing_type = 'R'
  and pet.closed_for_entry_flag = 'N'
  and pec.classification_id = pet.classification_id
  and pec.costing_debit_or_credit = 'D';

Line: 771

PROCEDURE chk_delete(p_pay_basis_id            number
                    ,p_object_version_number   number
                     ) is

l_exists  varchar2(1);

Line: 778

           select 'x'
           FROM per_all_assignments_f
           WHERE pay_basis_id = p_pay_basis_id;

Line: 783

           select 'x'
           FROM hr_all_positions_f
           WHERE  pay_basis_id = p_pay_basis_id;

Line: 788

           select 'x'
           FROM pay_element_links_f
           WHERE  pay_basis_id = p_pay_basis_id;

Line: 793

  l_proc         varchar2(72) := g_package||'chk_delete';

Line: 854

end chk_delete;

Line: 898

          select 'Y'
          from  PER_ALL_ASSIGNMENTS_F paa
         where paa.pay_basis_id  = p_rec.pay_basis_id;

Line: 1342

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

Line: 1366

End chk_non_updateable_args;

Line: 1371

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

Line: 1381

    select pbg.legislation_code
      into l_leg_code
      from per_business_groups_perf pbg
       where pbg.business_group_id = p_rec.business_group_id;

Line: 1448

End insert_validate;

Line: 1453

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

Line: 1461

 select pbg.legislation_code
      into l_leg_code
      from per_business_groups_perf pbg
         , per_pay_bases ppb
     where ppb.pay_basis_id = p_rec.pay_basis_id
       and pbg.business_group_id = ppb.business_group_id;

Line: 1491

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1538

End update_validate;

Line: 1543

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

Line: 1554

chk_delete(p_pay_basis_id           => p_rec.Pay_basis_id
          ,p_object_version_number  => p_rec.object_version_number
           );

Line: 1558

End delete_validate;