The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select
sum(absence_days)
From
per_absence_attendances paa
, per_absence_attendance_types pat
Where
pat.absence_attendance_type_id = paa.absence_attendance_type_id
And upper(pat.name) = upper(p_type)
And paa.date_start >= p_start_date
And paa.date_end <= p_end_date
And paa.date_end >= p_start_date
And paa.date_end <= p_end_date;
Select
paf.assignment_id,
paf.effective_start_date,
paf.effective_end_date,
paf.assignment_status_type_id
From
per_assignments_f paf,
per_assignment_status_types past,
pay_payrolls_f ppaf,
per_periods_of_service pos
Where
-------------------------------------------------------------------------------------
pos.PERSON_ID = paf.PERSON_ID
and nvl(pos.actual_termination_date, paf.effective_end_date) >= paf.EFFECTIVE_END_DATE
and paf.ASSIGNMENT_TYPE = 'E'
-------------------------------------------------------------------------------------
-- Per_Assignments_F
-- paf.person_id = nvl(p_person_id,paf.person_id)
And paf.person_id = p_person_id
And paf.payroll_id = p_payroll_id
And p_start_date <= paf.effective_end_date
And p_end_date >= paf.effective_start_date
And paf.assignment_status_type_id = past.assignment_status_type_id
And past.per_system_status = 'ACTIVE_ASSIGN'
-- Per_Payrolls_F
And paf.payroll_id = ppaf.payroll_id
And p_start_date <= ppaf.effective_end_date
And p_end_date >= ppaf.effective_start_date
Order by
2;