APPS.PAY_EEI_MIG_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
         , pay_element_type_extra_info eei
         , pay_element_types_f pet
     where eei.element_type_extra_info_id = p_element_type_extra_info_id
     and pbg.business_group_id = pet.business_group_id
     and pet.element_type_id = eei.element_type_id;

Line: 90

    select pbg.legislation_code
      from per_business_groups     pbg
         , pay_element_type_extra_info eei
         , pay_element_types_f pet
     where eei.element_type_extra_info_id = p_element_type_extra_info_id
     and pbg.business_group_id = pet.business_group_id
     and pet.element_type_id = eei.element_type_id;

Line: 497

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

Line: 528

End chk_non_updateable_args;

Line: 544

  select 'Y'
  from pay_input_values_f paf
  where element_type_id = p_element_type_id
  and   upper(name) = upper(p_qualifier)
  and   ((   paf.business_group_id is not null
         and paf.business_group_id = nvl(l_business_group_id,paf.business_group_id))
         or (   paf.legislation_code is not null
            and paf.business_group_id is null)
         or ( paf.legislation_code is null and paf.business_group_id is null )) ;

Line: 555

  select 'Y'
  from ff_globals_f fg
  where upper(fg.global_name) = upper(p_qualifier)
  and   (( fg.business_group_id is not null
         and fg.business_group_id = nvl(l_business_group_id,fg.business_group_id))
         or (   fg.legislation_code is not null
            and fg.business_group_id is null)
         or ( fg.legislation_code is null and fg.business_group_id is null )) ;

Line: 566

  select 'Y'
  from pay_rates pr
  where upper(name) = upper(p_qualifier)
  and rate_type = 'G'
  and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;

Line: 573

  select 'Y'
  from pay_rates pr
  where upper(name) like upper(p_qualifier)
  and rate_type = 'G'
  and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id);

Line: 581

  select 'Y'
  from pay_rates pr
  where upper(name) = upper(p_qualifier)
  and rate_type = 'SP'
  and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id) ;

Line: 588

  select 'Y'
  from pay_rates pr
  where upper(name) like upper(p_qualifier)
  and rate_type = 'SP'
  and pr.business_group_id = nvl(l_business_group_id,pr.business_group_id);

Line: 595

  select business_group_id
  from   pay_element_types_f pet
  where  pet.element_type_id = p_element_type_id ;

Line: 602

  SELECT 'Y'
  FROM   PAY_ELEMENT_TYPES_F pet
  WHERE  UPPER(pet.element_name) = UPPER(p_qualifier)
    AND  (( pet.business_group_id is not null
         and pet.business_group_id = nvl(l_business_group_id,
	                              pet.business_group_id))
         or (   pet.legislation_code is not null
            and pet.business_group_id is null)
         or ( pet.legislation_code is null
	      and pet.business_group_id is null )) ;

Line: 614

  SELECT 'Y'
  FROM    hr_lookups hrl
  WHERE   hrl.lookup_type    = 'PQP_RATE_TYPE'
    and   UPPER(hrl.meaning) = UPPER(p_qualifier)
    and   hrl.enabled_flag   = 'Y' ;

Line: 751

  SELECT 'Y'
    FROM PAY_INPUT_VALUES_F
   WHERE element_type_id = p_element_type_id
     AND UPPER(name)     = UPPER(p_input_value) ;

Line: 858

select 1
from pay_element_type_extra_info
where element_type_id = p_element_type_id
and element_type_extra_info_id <> nvl(p_element_type_extra_info_id, -1)
and information_type = 'PQP_UK_RATE_TYPE'
and eei_information1 = p_rate_type;

Line: 897

select 1
from pay_element_type_extra_info
where element_type_id <> p_element_type_id
  and information_type = p_information_type
  and upper(eei_information2) = upper(p_element_code);

Line: 908

    select 1
    from pay_element_type_extra_info
    where element_type_id = p_element_type_id
      and information_type = p_info_type;

Line: 974

Procedure insert_validate
  (p_rec                          in pay_eei_mig_shd.g_rec_type
  ) is
--
  cursor row_type(p_element_type_id number)
  is
  select business_group_id
  from   pay_element_types_f
  where  element_type_id = p_element_type_id
  and    business_group_id is not null
  and    rownum = 1;

Line: 987

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

Line: 1062

End insert_validate;

Line: 1067

Procedure update_validate
  (p_rec                          in pay_eei_mig_shd.g_rec_type
  ) is
--
  cursor row_type(p_element_type_id number)
  is
  select business_group_id
  from   pay_element_types_f
  where  element_type_id = p_element_type_id
  and    business_group_id is not null
  and    rownum = 1;

Line: 1080

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

Line: 1104

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1156

End update_validate;

Line: 1161

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

Line: 1173

End delete_validate;