The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT NVL(PTP.start_date, END_OF_TIME)
FROM per_time_periods PTP
,per_assignments_f ASS
WHERE ASS.assignment_id = p_assignment_id
AND p_upload_date BETWEEN ASS.effective_start_date AND ASS.effective_end_date
AND PTP.payroll_id = ASS.payroll_id
AND p_upload_date BETWEEN PTP.start_date AND PTP.end_date;
SELECT NVL(GREATEST(MIN(ASS.effective_start_date), p_expiry_date),END_OF_TIME)
FROM per_assignments_f ASS
WHERE ASS.assignment_id = p_assignment_id
AND ASS.effective_start_date <= p_upload_date
AND ASS.effective_end_date >= p_expiry_date;
SELECT tba.source_text , tba.tax_unit_id
FROM pay_temp_balance_adjustments tba,
pay_balance_batch_lines bbl
WHERE tba.balance_type_id = bbl.balance_type_id
AND tba.batch_line_id = p_test_batch_line_id
AND bbl.batch_line_id = p_batch_line_id
AND nvl(tba.source_text ,0) = nvl(bbl.source_text ,0);