The following lines contain the word 'select', 'insert', 'update' or 'delete':
select value
from per_assignment_budget_values_f
where assignment_id = p_assignment_id
and unit = p_ABV
and p_session_date between effective_start_date and effective_end_date;
select 'Y'
from per_job_extra_info
where information_type = 'Job Category'
and JEI_INFORMATION1 = p_job_category
and job_id = p_job_id;
SELECT formula_id
FROM ff_formulas_f
WHERE business_group_id+0 = p_business_group_id
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
AND formula_name = 'HR_MOVE_TYPE';
SELECT formula_id
FROM ff_formulas_f
WHERE business_group_id+0 is null
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
AND formula_name = 'HR_MOVE_TYPE_TEMPLATE';
select ast.per_system_status status
, asg.effective_start_date
, asg.effective_end_date
, asg.organization_id
from per_assignment_status_types ast
, per_all_assignments_f asg
where asg.assignment_status_type_id = ast.assignment_status_type_id
and asg.assignment_id = p_assignment_id
and asg.effective_start_date <= p_period_end_date
order by asg.effective_start_date desc;
select per.start_date
from per_all_people_f per
, per_all_assignments_f asg
where asg.person_id = per.person_id
and p_period_end_date between per.effective_start_date and per.effective_end_date
and p_period_end_date between asg.effective_start_date and asg.effective_end_date
and asg.assignment_id = p_assignment_id;
select pos.actual_termination_date
from per_periods_of_service pos
,per_all_assignments_f asg
where asg.period_of_service_id = pos.period_of_service_id
and p_period_start_date-1 between asg.effective_start_date
and asg.effective_end_date
and asg.assignment_id = p_assignment_id;
select pps.actual_termination_date
from per_periods_of_placement pps
,per_all_assignments_f asg
where asg.person_id = pps.person_id
and asg.period_of_placement_date_start = pps.date_start
and p_period_start_date-1 between asg.effective_start_date
and asg.effective_end_date
and asg.assignment_id = p_assignment_id;
select 'Y'
from per_periods_of_service pos
where pos.date_start between add_months(p_report_date,-1) and p_report_date
and pos.period_of_service_id in (
select paf.period_of_service_id
from per_all_assignments_f paf
where paf.period_of_service_id = pos.period_of_service_id
and paf.organization_id = p_organization_id
and paf.assignment_id = p_assignment_id);
select 'Y'
from per_periods_of_service pos
where pos.date_start between p_cur_date_from and p_cur_date_to
and pos.period_of_service_id in (
select paf.period_of_service_id
from per_all_assignments_f paf
where paf.period_of_service_id = pos.period_of_service_id
and paf.organization_id = p_organization_id
and paf.assignment_id = p_assignment_id);
select 'Y'
from per_periods_of_placement pps
where pps.date_start between p_cur_date_from and p_cur_date_to
and exists (select 1
from per_all_assignments_f paf
where paf.person_id = pps.person_id
and paf.period_of_placement_date_start = pps.date_start
and paf.organization_id = p_organization_id
and paf.assignment_id = p_assignment_id);
select substr(org_information1,1,60)
from hr_organization_information
where organization_id = P_ORGANIZATION_ID
and org_information_context = 'Organization Name Alias'
and P_REPORT_DATE between
nvl(fnd_date.canonical_to_date(org_information3),hr_api.g_sot)
and nvl(fnd_date.canonical_to_date(org_information4),hr_api.g_eot);
select name
from hr_organization_units
where organization_id = P_ORGANIZATION_ID
and P_REPORT_DATE between date_from and
nvl(date_to,to_date('31/12/4712','DD/MM/YYYY'));
select formula_name
from ff_formulas_f
where formula_id = p_formula_id;
select formula_type_id
from ff_formula_types
where upper(formula_type_name) = upper(p_formula_type_name);
SELECT formula_id
FROM ff_formulas_f
WHERE business_group_id+0 = p_business_group_id
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
AND formula_name = p_formula_name
AND formula_type_id
= HR_PERSON_FLEX_LOGIC.GetFormulaTypeID(p_formula_type);
SELECT formula_id
FROM ff_formulas_f
WHERE business_group_id+0 is null
AND SYSDATE BETWEEN effective_start_date AND effective_end_date
AND formula_name = p_formula_name||'_TEMPLATE'
AND formula_type_id
= HR_PERSON_FLEX_LOGIC.GetFormulaTypeID(p_formula_type);