The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT
asg.assignment_number assignment_number
, pro.proposed_salary_n salary_amount
, ppb.pay_annualization_factor annualization_factor
, ppb.pay_annualization_factor * pro.proposed_salary_n annual_salary
FROM per_assignments_f asg /* Secure */
, per_pay_bases ppb
, per_pay_proposals pro
, per_pay_proposals pro_next
, pay_input_values_f piv
, pay_element_types_f pet
, pay_payrolls_f pay /* Secure */
WHERE
/* Joins inc. date joins */
pro.assignment_id = asg.assignment_id
AND pro.change_date BETWEEN asg.effective_start_date
AND asg.effective_end_date
/* only show people who have a salary */
AND asg.pay_basis_id = ppb.pay_basis_id
/* Next Pay proposal to get date */
AND pro.assignment_id = pro_next.assignment_id
AND pro.change_date = pro_next.last_change_date
/* Element entry types and currencies */
AND ppb.input_value_id = piv.input_value_id
AND piv.element_type_id = pet.element_type_id
AND pro.change_date BETWEEN pet.effective_start_date
AND pet.effective_end_date
/* Payrolls and periods */
AND asg.payroll_id = pay.payroll_id
AND pro.change_date BETWEEN pay.effective_start_date
AND pay.effective_end_date
AND pro_next.pay_proposal_id = cp_pay_proposal_id;
select annual_salary
from HRIFV_SAL_PRO
where assignment_id = cp_assignment_id
and cp_effective_date between effective_from_date and effective_to_date_nn;