[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
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_name = p_element_name
and (et.business_group_id + 0 = p_business_group_id
or (et.business_group_id is null
and et.legislation_code = hr_api.return_legislation_code(p_business_group_id)
))
and et_tl.element_type_id = et.element_type_id
and et_tl.language = p_language_code;
select pas.assignment_status_type_id
into l_ass_status_typ_id
from per_assignment_status_types_tl pastl
,per_assignment_status_types pas
,per_ass_status_type_amends asta
where pas.assignment_status_type_id = pastl.assignment_status_type_id
and pastl.language = p_language_code
and nvl(asta.user_status,pastl.user_status) = p_user_status
and asta.assignment_status_type_id(+) = pas.assignment_status_type_id
and asta.business_group_id(+) = p_business_group_id
and nvl(pas.business_group_id,nvl(p_business_group_id,0))
= nvl(p_business_group_id,0)
and nvl(pas.legislation_code
,nvl(hr_api.return_legislation_code(p_business_group_id),' '))
= nvl(hr_api.return_legislation_code(p_business_group_id),' ');
select status_processing_rule_id
into l_spr_id
from pay_status_processing_rules_f spr
where spr.element_type_id = l_element_type_id
and p_effective_date between spr.effective_start_date
and spr.effective_end_date
and (spr.business_group_id + 0 = p_business_group_id
or (spr.business_group_id is null
and spr.legislation_code = hr_api.return_legislation_code(p_business_group_id)
))
and nvl(spr.assignment_status_type_id,-1) = nvl(l_ass_status_typ_id,-1);
select frr.object_version_number
into l_frr_ovn
from pay_formula_result_rules_f frr,
hr_pump_batch_line_user_keys key
where key.user_key_value = p_formula_result_rule_user_key
and frr.formula_result_rule_id = key.unique_key_id
and p_effective_date between frr.effective_start_date
and frr.effective_end_date;