The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT pi.phase_item_id, pi.table_name, pi.status, tbl.short_name
FROM hr_dm_phase_items pi,
hr_dm_tables tbl
WHERE pi.status = 'NS'
AND mod(pi.phase_item_id,l_no_of_threads) + 1 = p_process_number
AND pi.phase_id = l_phase_id
AND pi.table_name = tbl.table_name;
SELECT business_group_id, migration_type
FROM hr_dm_migrations
WHERE migration_id = p_migration_id;
hr_dm_utility.update_phase_items(p_new_status => 'S',
p_id => l_phase_item_id);
hr_dm_utility.update_phase_items(p_new_status => 'C',
p_id => l_phase_item_id);
hr_dm_utility.update_phase_items(p_new_status => 'E',
p_id => l_phase_item_id);