The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT timer_id,timer_message_code,next_timer
FROM xnp_timer_registry
WHERE
reference_id=p_msg_header.reference_id
AND
(
timer_message_code = p_message_code
OR
next_timer= p_message_code
)
AND status = 'ACTIVE';
INSERT INTO xnp_timer_registry (
timer_id,
reference_id,
timer_message_code,
status,
start_time,
end_time,
next_timer,
order_id,
wi_instance_id,
fa_instance_id,
created_by,
creation_date,
last_updated_by,
last_update_date
)
VALUES (
p_msg_header.message_id,
p_msg_header.reference_id,
p_msg_header.message_code,
'ACTIVE',
l_start_time,
l_end_time,
p_dummy_for,
p_msg_header.order_id,
p_msg_header.wi_instance_id,
p_msg_header.fa_instance_id,
fnd_global.user_id,
sysdate,
fnd_global.user_id,
sysdate
);