The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT qpc.plan_id
FROM qa_plan_chars qpc, qa_plans qp
WHERE qpc.plan_id = qp.plan_id AND
qpc.char_id = qa_ss_const.party_name AND
qp.organization_id <> 0;
UPDATE qa_results qr
SET qr.party_id = p_to_fk_id,
qr.last_update_date = sysdate,
qr.qa_last_update_date = sysdate,
qr.last_update_login = hz_utility_pub.last_update_login,
qr.last_updated_by = hz_utility_pub.user_id,
qr.qa_last_updated_by = hz_utility_pub.user_id,
qr.request_id = hz_utility_pub.request_id,
qr.program_application_id = hz_utility_pub.program_application_id,
qr.program_id = hz_utility_pub.program_id,
qr.program_update_date = sysdate
WHERE qr.party_id = p_from_fk_id;