The following lines contain the word 'select', 'insert', 'update' or 'delete':
select assignment_id
from pay_assignment_actions paa
, pay_payroll_actions ppa
where paa.assignment_action_id = c_assignment_action_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B');
select pdb.defined_balance_id
from pay_defined_balances pdb
, pay_balance_dimensions pbd
where pdb.balance_dimension_id = pbd.balance_dimension_id
and pbd.database_item_suffix = c_db_item_suffix
and pdb.balance_type_id = c_balance_type_id;
select to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16))
from per_assignments_f paf
, pay_assignment_actions paa
, pay_payroll_actions ppa
where paa.assignment_id = c_assignment_id
and paf.assignment_id = paa.assignment_id
and ppa.payroll_action_id = paa.payroll_action_id
and ppa.effective_date <= c_effective_date
and ppa.action_type in ('R', 'Q', 'I', 'V', 'B')
and paa.action_status='C'
and ppa.payroll_id = paf.payroll_id
and ppa.effective_date between paf.effective_start_date and paf.effective_end_date
and ppa.action_status='C' ; /*Bug - 3019374 */
select ppa.effective_date
from pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.payroll_action_id = ppa.payroll_action_id
and paa.assignment_action_id = p_assignment_action_id;
select business_group_id
from per_assignments_f
where assignment_id = p_assignment_id;
select business_group_id
from per_assignments_f
where assignment_id = p_assignment_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;
select ptp.end_date
from per_time_periods ptp
, pay_payroll_actions ppa
, pay_assignment_actions paa
where paa.assignment_action_id = c_assignment_action_id
and paa.payroll_action_id = ppa.payroll_action_id
and ppa.time_period_id = ptp.time_period_id;