APPS.PAY_NZ_CEC_REPORT_PKG SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 33

select paa.assignment_action_id
from pay_assignment_actions paa,
     pay_payroll_actions ppa
where ppa.action_status ='C'
and ppa.action_type in ('R','Q','I','B','V')
and ppa.effective_date between p_start_date and p_end_date
and paa.payroll_action_id=ppa.payroll_action_id
and paa.assignment_id =p_assignment_id;