The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
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';
End chk_non_updateable_args;
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 )) ;
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 )) ;
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) ;
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);
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) ;
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);
select business_group_id
from pay_element_types_f pet
where pet.element_type_id = p_element_type_id ;
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 )) ;
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' ;
SELECT 'Y'
FROM PAY_INPUT_VALUES_F
WHERE element_type_id = p_element_type_id
AND UPPER(name) = UPPER(p_input_value) ;
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;
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);
select 1
from pay_element_type_extra_info
where element_type_id = p_element_type_id
and information_type = p_info_type;
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;
l_proc varchar2(72) := g_package||'insert_validate';
End insert_validate;
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;
l_proc varchar2(72) := g_package||'update_validate';
chk_non_updateable_args
(p_rec => p_rec
);
End update_validate;
Procedure delete_validate
(p_rec in pay_eei_mig_shd.g_rec_type
) is
--
l_proc varchar2(72) := g_package||'delete_validate';
End delete_validate;