The following lines contain the word 'select', 'insert', 'update' or 'delete':
select unique_key_id
into l_id
from hr_pump_batch_line_user_keys
where user_key_value = p_user_key_value;
select els.element_set_id
into l_element_set_id
from pay_element_sets els
where upper(els.element_set_name) = upper(p_element_set_name)
and nvl(els.business_group_id,nvl(p_business_group_id,0)) =
nvl(p_business_group_id,0);
select pel.object_version_number
into l_element_link_ovn
from pay_element_links_f pel,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_element_link_user_key
and pel.element_link_id = key.unique_key_id
and p_effective_date between
pel.effective_start_date and pel.effective_end_date;
select liv.link_input_value_id
into l_link_input_value_id
from pay_link_input_values_f liv,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_element_link_user_key
and liv.element_link_id = key.unique_key_id
and liv.input_value_id = l_input_value_id
and p_effective_date between liv.effective_start_date
and liv.effective_end_date;
select liv.object_version_number
into l_link_input_value_ovn
from pay_link_input_values_f liv
where liv.link_input_value_id = l_link_input_value_id
and p_effective_date between liv.effective_start_date
and liv.effective_end_date;
Select pay.classification_id
into l_classification_id
From pay_element_classifications pay,
pay_element_classifications_tl paytl
Where pay.classification_id = paytl.classification_id
and paytl.language = userenv('LANG')
and pay.parent_classification_id is null
and nvl(pay.legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(pay.business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and paytl.classification_name = p_classification_name;
Select formula_id
into l_formula_id
From ff_formulas_f f1,
ff_formula_types f2
Where f1.formula_type_id = f2.formula_type_id
and f2.formula_type_name = 'Element Skip'
and p_effective_date between f1.effective_start_date and
f1.effective_end_date
and nvl(legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and upper(formula_name) = upper(p_formula_Name);
Select benefit_classification_id
INTO l_benefit_classification_id
From ben_benefit_classifications
Where nvl(legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and benefit_classification_name = p_benefit_classification_name ;
Select formula_id
INTO l_formula_id
From ff_formulas_f f1, ff_formula_types f2
Where f1.formula_type_id = f2.formula_type_id
and f2.formula_type_name = 'Net to Gross'
and p_effective_date between f1.effective_start_date and
f1.effective_end_date
and nvl(legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')) =
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and upper(formula_name) = upper(p_iterative_formula_name) ;
Select et.element_type_id
INTO l_element_type_id
From pay_element_classifications ec, pay_element_types_f et
Where ec.classification_id = et.classification_id
and p_effective_date between et.effective_start_date and
et.effective_end_date
and nvl(et.legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(et.business_group_id, nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and et.element_name = p_retro_summ_element_name ;
Select event_group_id
INTO l_event_group_id
From pay_event_groups peg
Where peg.event_group_type = 'P'
and (peg.legislation_code =
HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)
or ( peg.legislation_code is null and
peg.business_group_id = p_business_group_id)
or ( peg.legislation_code is null and
peg.business_group_id is null))
and event_group_name = p_event_group_name;
Select formula_id
INTO l_formula_id
From ff_formulas_f f1, ff_formula_types f2
Where f1.formula_type_id = f2.formula_type_id
and f2.formula_type_name = 'Payroll Run Proration'
and p_effective_date between f1.effective_start_date and
f1.effective_end_date
and nvl(legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and upper(formula_name) = upper(p_proration_formula_Name) ;
Select event_group_id
INTO l_event_group_id
From pay_event_groups
Where event_group_type = 'R'
and (legislation_code = HR_API.RETURN_LEGISLATION_CODE(p_business_group_id)
or ( legislation_code is null and
business_group_id = p_business_group_id)
or ( legislation_code is null and
business_group_id is null))
and event_group_name = p_recalc_event_group_name;
Select pet.object_version_number
into l_element_type_ovn
From pay_element_types_f pet,
hr_pump_batch_line_user_keys key
Where key.user_key_value = p_element_type_user_key
and pet.element_type_id = key.unique_key_id
and p_effective_date between
pet.effective_start_date and pet.effective_end_date;
Select piv.object_version_number
into l_input_value_ovn
From pay_input_values_f piv
Where piv.input_value_id = l_input_value_id
and p_effective_date between
piv.effective_start_date and piv.effective_end_date;
Select formula_id
INTO l_formula_id
From ff_formulas_f ff,
ff_formula_types ft
Where nvl(ff.legislation_code,
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~'))=
nvl(HR_API.RETURN_LEGISLATION_CODE(p_business_group_id),'~~nvl~~')
and nvl(ff.business_group_id, nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1)
and p_effective_date between ff.effective_start_date and
ff.effective_end_date
and ff.formula_type_id = ft.formula_type_id
and upper (ft.formula_type_name) = 'ELEMENT INPUT VALIDATION'
and upper(formula_name) = upper(p_input_formula_name) ;
select pettl.element_name
into l_element_name
from pay_element_types_f pet,
pay_element_types_f_tl pettl,
hr_pump_batch_line_user_keys
where pettl.language = p_language_code
and pet.element_type_id = pettl.element_type_id
and p_effective_date between
pet.effective_start_date and pet.effective_end_date
and pet.element_type_id = unique_key_id
and user_key_value = p_element_type_user_key ;