The following lines contain the word 'select', 'insert', 'update' or 'delete':
select rule_mode
from pay_legislation_rules
where legislation_code='KW'
and rule_type = 'L';
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(MIN(ass.effective_start_date), END_OF_TIME)
FROM per_assignments_f ass
WHERE ass.assignment_id = p_assignment_id
AND ass.payroll_id IS NOT NULL
AND ass.effective_start_date <= p_upload_date;
select
nvl(ppf.effective_start_date, END_OF_TIME)
from
per_all_assignments_f ass,
pay_all_payrolls_f ppf
where
ass.assignment_id = p_assignment_id
and p_upload_date between
nvl(ass.effective_start_date,p_upload_date) and
nvl(ass.effective_end_date,p_upload_date)
and ppf.payroll_id = ass.payroll_id
and p_upload_date between
nvl(ppf.effective_start_date,p_upload_date) and
nvl(ppf.effective_end_date,p_upload_date);
SELECT tba.source_text,tba.balance_type_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;
select source_text into l_source_text1 from pay_balance_batch_lines where batch_line_id=p_batch_line_id;