The following lines contain the word 'select', 'insert', 'update' or 'delete':
select
greatest(min(asg.effective_start_date)
,min(ptp.start_date))
from
per_all_assignments_f asg
,per_time_periods ptp
where asg.assignment_id = p_assignment_id
and ptp.payroll_id = asg.payroll_id
and ptp.start_date <= asg.effective_end_date;
SELECT ptp.start_date
FROM per_all_assignments_f ass
,per_time_periods ptp
WHERE ass.assignment_id = p_assignment_id
AND ass.effective_start_date <= p_upload_date
AND ass.effective_end_date >= p_upload_date
AND ptp.payroll_id = ass.payroll_id
AND p_upload_date BETWEEN ptp.start_date
AND ptp.end_date;
SELECT TO_DATE('0104'||TO_CHAR(p_upload_date,'YYYY'),'DD/MM/YYYY')
INTO l_holiday_year
FROM DUAL;
SELECT tba.source_text , tba.tax_unit_id
FROM pay_temp_balance_adjustments tba,
pay_balance_batch_lines bbl
WHERE tba.batch_line_id = p_test_batch_line_id
AND bbl.batch_line_id = p_batch_line_id
AND nvl(tba.balance_type_id ,0) = nvl(bbl.balance_type_id ,0)
AND nvl(tba.source_text ,0) = nvl(bbl.source_text ,0)
AND nvl(tba.tax_unit_id,0) = nvl(bbl.tax_unit_id,0)
AND tba.tax_unit_id IS NOT NULL
AND tba.source_text IS NOT NULL;