APPS.PAY_EGU_BUS SQL Statements

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

Line: 28

    select pbg.security_group_id,
           pbg.legislation_code
      from per_business_groups_perf pbg
         , pay_event_group_usages egu
     where egu.event_group_usage_id = p_event_group_usage_id
       and pbg.business_group_id (+) = egu.business_group_id;

Line: 99

    select pbg.legislation_code
      from per_business_groups_perf pbg
         , pay_event_group_usages egu
     where egu.event_group_usage_id = p_event_group_usage_id
       and pbg.business_group_id (+) = egu.business_group_id;

Line: 170

  (p_insert               IN boolean
  ,p_business_group_id    IN number
  ,p_legislation_code     IN varchar2
  ,p_legislation_subgroup IN varchar2 DEFAULT NULL) IS
--
BEGIN
  --

  IF (p_insert) THEN

    if p_business_group_id is not null and p_legislation_code is not null then
        fnd_message.set_name('PAY', 'PAY_33179_BGLEG_INVALID');

Line: 241

select pes.legislation_code , pes.business_group_id, pes.element_set_type
from   pay_element_sets pes
where  pes.element_set_id = p_element_set_id ;

Line: 347

select peg.legislation_code , peg.business_group_id
from   pay_event_groups peg
where  peg.event_group_id = p_event_group_id ;

Line: 449

select  null
from    pay_event_group_usages egu
where   egu.event_group_id = p_event_group_id
and     egu.element_set_id = p_element_set_id
and ( p_business_group_id is null
        or ( p_business_group_id is not null and p_business_group_id = egu.business_group_id )
        or ( p_business_group_id is not null and
                egu.legislation_code is null and egu.business_group_id is null )
        or ( p_business_group_id is not null and
                egu.legislation_code = hr_api.return_legislation_code(p_business_group_id )))
and ( p_legislation_code is null
        or ( p_legislation_code is not null and p_legislation_code = egu.legislation_code )
        or ( p_legislation_code is not null and
                egu.legislation_code is null and egu.business_group_id is null)
        or ( p_legislation_code is not null and
                p_legislation_code = hr_api.return_legislation_code(egu.business_group_id )));

Line: 542

select null
from fnd_territories
where territory_code = p_legislation_code ;

Line: 581

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

Line: 651

End insert_validate;

Line: 656

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

Line: 687

End delete_validate;