The following lines contain the word 'select', 'insert', 'update' or 'delete':
v_SQL := 'select group_id from gl_consolidation_history ' ||
'where consolidation_id = :cons_id ' ||
'and consolidation_run_id = :cons_run_id';
v_WaitSQL := 'select domain_name ' ||
'from rg_database_links ' ||
'where name = :pd';