APPS.PAY_EEI_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_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: 624

  SELECT 'Y'
  FROM   pay_user_tables put
  where  upper(user_table_name)=UPPER(p_qualifier)
  and   ((   put.business_group_id is not null
         and put.business_group_id = nvl(l_business_group_id,put.business_group_id))
         or (   put.legislation_code is not null
            and put.business_group_id is null)
         or ( put.legislation_code is null and put.business_group_id is null )) ;

Line: 775

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

Line: 826

select 'Y'
from  pay_user_columns puc, pay_user_tables put
where puc.user_table_id = put.user_table_id
and   upper(put.user_table_name)= upper(p_eei_information3)
and   upper(puc.user_column_name) = upper(p_eei_information17);

Line: 833

select 'Y'
from PAY_USER_ROWS_F pur, pay_user_tables put, fnd_sessions ses
where ses.session_id = userenv('SESSIONID')
and   pur.user_table_id = put.user_table_id
and   upper(put.user_table_name)= upper(p_eei_information3)
and   upper(pur.ROW_LOW_RANGE_OR_NAME) = upper(p_eei_information19)
and   ses.effective_date between pur.effective_start_date
                             and pur.effective_end_date;

Line: 843

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

Line: 988

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: 1029

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: 1037

select 1
from pay_legislation_rules
where legislation_code = 'GB'
  and rule_type like 'ADVANCED_RETRO'
  and rule_mode = 'Y';

Line: 1045

select 1
from pay_element_type_extra_info petei,pay_element_types_f pet
where petei.element_type_id <> p_element_type_id
  and information_type = p_information_type
  and upper(eei_information2) = upper(p_element_code)
  and petei.element_type_id not in ((select element_type_id
                                    from pay_element_types_f
                                    where retro_summ_ele_id = p_element_type_id)
                                  union
                                  (select retro_summ_ele_id
                                    from pay_element_types_f
                                    where element_type_id = p_element_type_id
                                    and retro_summ_ele_id IS NOT NULL ))
 and pet.element_type_id=petei.element_type_id
 and rownum =1;

Line: 1063

select 1
from pay_element_type_extra_info petei,pay_element_types_f pet
where petei.element_type_id <> p_element_type_id
  and information_type = p_information_type
  and upper(eei_information2) = upper(p_element_code)
  and petei.element_type_id not in ((select prcu.creator_id
                                    from pay_element_span_usages pesu, pay_retro_component_usages prcu
                                    where pesu.retro_element_type_id = p_element_type_id
                                    and pesu.retro_component_usage_id = prcu.retro_component_usage_id
                                    and prcu.creator_type = 'ET')
                                    union
                                    (select pesu.retro_element_type_id
                                    from pay_element_span_usages pesu, pay_retro_component_usages prcu
                                    where prcu.creator_id = p_element_type_id
                                    and pesu.retro_component_usage_id = prcu.retro_component_usage_id
                                    and prcu.creator_type = 'ET'))
 and pet.element_type_id=petei.element_type_id
 and rownum =1;

Line: 1085

select 1
from pay_element_types_f
where retro_summ_ele_id = p_element_type_id;

Line: 1095

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

Line: 1206

    SELECT 1
    FROM pay_element_types_f pet
    ,pay_input_values_f piv
    WHERE piv.element_type_id = pet.element_type_id
    AND pet.element_type_id = p_element_type_id
    AND (pet.processing_type = 'N'
    AND UPPER(piv.NAME) = UPPER('CLAIM DATE'))
    AND rownum = 1;

Line: 1255

    SELECT pet.element_name
        ,pet.processing_type
        ,piv.uom
    FROM pay_element_types_f pet,
    pay_input_values_f piv
    WHERE pet.element_type_id = p_element_type_id
    AND pet.element_type_id = piv.element_type_id (+)
    AND upper(piv.NAME (+)) = 'CLAIM DATE';

Line: 1293

Procedure insert_validate
  (p_rec                          in pay_eei_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: 1306

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

Line: 1417

End insert_validate;

Line: 1422

Procedure update_validate
  (p_rec                          in pay_eei_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: 1435

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

Line: 1462

  chk_non_updateable_args
    (p_rec              => p_rec
    );

Line: 1546

End update_validate;

Line: 1551

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

Line: 1563

End delete_validate;