The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT rei_information3 payroll_id
FROM ghr_pa_request_extra_info
WHERE pa_request_id = c_pa_request_id
AND information_type = 'GHR_US_PAR_PAYROLL_TYPE';
SELECT min(start_date) start_date
FROM per_time_periods
WHERE payroll_id = c_payroll_id
AND TO_CHAR(start_date,'YYYY') = c_year
AND TO_CHAR(start_date,'MM') = c_month;
select 'Y'
from per_all_assignments_f pasf1, per_all_assignments_f pasf2
where pasf2.person_id = pasf1.person_id
AND pasf2.assignment_id = p_assignment_id
AND p_effective_date between pasf2.effective_start_date and pasf2.effective_end_date
and (p_effective_date - num_of_days) between pasf1.effective_start_date and pasf1.effective_end_date
and pasf1.assignment_type <> 'B';
SELECT first_noa_information1
FROM ghr_pa_requests
WHERE pa_request_id = p_pa_request_id;
Select asg.effective_start_date
from per_all_assignments_f asg
Where asg.assignment_id = p_assignment_id
and asg.primary_flag = 'Y'
and asg.assignment_type <> 'B'
order by asg.effective_start_date;
SELECT 1
FROM pay_element_entries_f ele
WHERE ele.assignment_id = c_assignment_id
AND c_effective_date BETWEEN ele.effective_start_date AND ele.effective_end_date
AND element_type_id = c_element_type_id;
SELECT elt.element_type_id
FROM pay_element_links eli, pay_element_types_f elt
WHERE elt.element_type_id = eli.element_type_id
AND eli.business_group_id = c_business_group_id
AND elt.element_name = c_element_name;
SELECT a.element_name element_name,
b.name ipv_name,
f.input_value_id input_value_id,
e.effective_start_date effective_start_date,
e.effective_end_date effective_end_date,
e.element_entry_id element_entry_id,
e.assignment_id assignment_id,
e.object_version_number object_version_number,
f.element_entry_value_id element_entry_value_id,
f.screen_entry_value screen_entry_value
FROM pay_element_types_f a,
pay_input_values_f b,
pay_element_entries_f e,
pay_element_entry_values_f f,
pay_element_links_f g
WHERE a.element_type_id = b.element_type_id
AND e.element_type_id = a.element_type_id
AND f.element_entry_id = e.element_entry_id
AND f.input_value_id = b.input_value_id
AND g.element_type_id = a.element_type_id
AND c_effective_date between g.effective_start_date and g.effective_end_date
AND c_effective_date between a.effective_start_date and a.effective_end_date
AND c_effective_date between b.effective_start_date and b.effective_end_date
AND c_effective_date between f.effective_start_date and f.effective_end_date
AND g.business_group_id = c_business_group_id
--and e.effective_start_date = f.effective_start_date
--and e.effective_end_date = f.effective_end_date
and e.assignment_id = c_assignment_id
and a.element_name = c_element_name
AND c_effective_date BETWEEN e.effective_start_date AND e.effective_end_date;
SELECT person_id
FROM per_all_assignments_f asg
WHERE asg.assignment_id = c_assignment_id
AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
SELECT element_name
FROM pay_element_types_f pet, pay_element_links_f pel
where pet.element_type_id = pel.element_type_id
and c_effective_date between pel.effective_start_date and pel.effective_end_date
and pel.business_group_id = c_business_group_id
and pel.element_link_id = c_element_link_id;
select ele.element_entry_id,
ele.object_version_number
from pay_element_types_f elt,
pay_element_links_f eli,
pay_element_entries_f ele
where ele.assignment_id = p_assignment_id
and upper(elt.element_name) = upper('TSP Roth 401K')
and elt.element_type_id = eli.element_type_id + 0
and elt.element_type_id = ele.element_type_id + 0
and ele.element_link_id = eli.element_link_id
and (elt.business_group_id is null or elt.business_group_id = p_bg_id)
and trunc(p_eff_dt) between elt.effective_start_date
and elt.effective_end_date
and trunc(p_eff_dt) between eli.effective_start_date
and eli.effective_end_date
and trunc(p_eff_dt) between ele.effective_start_date
and ele.effective_end_date;
py_element_entry_api.delete_element_entry(
p_datetrack_delete_mode => 'DELETE',
p_effective_date => (p_effective_date - 1),
p_element_entry_id => rec_get_tsp_roth_eff.element_entry_id,
p_object_version_number => rec_get_tsp_roth_eff.object_version_number,
p_effective_start_date => l_eff_start_date,
p_effective_end_date => l_eff_end_date,
p_delete_warning => l_warning);
PROCEDURE validate_update_element(
p_effective_date in date
,P_ASSIGNMENT_ID_O in number default null
,p_validation_start_date in date
,p_validation_end_date in date
,p_element_entry_id in number
,p_effective_start_date in date
,p_effective_end_date in date
,P_ELEMENT_LINK_ID_O in number default null
,P_ELEMENT_TYPE_ID_O in number default null
) IS
BEGIN
IF g_debug = TRUE THEN
hr_utility.set_location('Entering validate_update_element',110);
END validate_update_element;
SELECT assignment_type, assignment_id
FROM per_all_assignments_f asg
WHERE asg.person_id = c_person_id
AND c_effective_date BETWEEN asg.effective_start_date AND asg.effective_end_date;
SELECT effective_date
FROM fnd_sessions
WHERE session_id = c_session_id;
SELECT *
FROM per_people_extra_info ppei
WHERE ppei.person_extra_info_id = c_per_extra_info_id
AND ppei.information_type = c_information_type;
SELECT noa_family_code
FROM ghr_noa_families
WHERE nature_of_action_id = c_noa_id
AND c_effective_date BETWEEN NVL(start_date_active,to_date('01/01/1951','dd/mm/yyyy'))
AND NVL(end_date_active,to_date('31/12/4712','dd/mm/yyyy'));