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 et.element_type_id
into l_element_type_id
from pay_element_types_f et,
pay_element_types_f_tl et_tl
where et_tl.element_type_id = et.element_type_id
and et_tl.element_name = p_element_name
and p_effective_date between et.effective_start_date and
et.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 et_tl.language = p_language_code;
Select distinct formula_id
into l_formula_id
From ff_formulas_f f1,
ff_formula_types f2
Where f2.formula_type_id = f1.formula_type_id
and f2.formula_type_name in('Oracle Payroll' , 'Balance Adjustment')
and UPPER(f1.formula_name) = UPPER(p_formula_Name)
and nvl(f1.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(f1.business_group_id,nvl(p_business_group_id,-1)) =
nvl(p_business_group_id,-1) ;
Select lookup_code, meaning
from hr_lookups
Where lookup_type = 'NAME_TRANSLATIONS'
and lookup_code in ('STANDARD','BAL_ADJUST');
select astp.assignment_status_type_id
into l_ass_status_typ_id
from per_assignment_status_types_tl astpl,
per_assignment_status_types astp
where astpl.assignment_status_type_id = astp.assignment_status_type_id
and UPPER(astpl.user_status) = UPPER(p_assignment_status)
and nvl(astp.business_group_id,nvl(p_business_group_id,0))
= nvl(p_business_group_id,0)
and nvl(astp.legislation_code
,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
= nvl(hr_api.return_legislation_code(p_business_group_id),' ');
select spr.object_version_number
into l_spr_ovn
from pay_status_processing_rules_f spr,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_status_process_rule_user_key
and spr.status_processing_rule_id = key.unique_key_id
and p_effective_date between spr.effective_start_date
and spr.effective_end_date;