The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT tbl.loader_name,
tbl.loader_conc_program,
tbl.loader_config_file,
tbl.loader_application,
lp.parameter1, lp.parameter2,
lp.parameter3, lp.parameter4,
lp.parameter4, lp.parameter6,
lp.parameter5, lp.parameter8,
lp.parameter7, lp.parameter10,
lp.application_id
FROM hr_dm_tables tbl,
hr_dm_loader_params lp,
hr_dm_phase_items pi
WHERE (pi.phase_item_id = p_phase_item_id)
AND (pi.loader_params_id = lp.loader_params_id)
AND (lp.table_id = tbl.table_id);
hr_dm_master.insert_request(p_phase => 'C',
p_request_id => l_request_id,
p_master_slave => 'S',
p_migration_id => p_migration_id,
p_phase_id => p_phase_id,
p_phase_item_id => p_phase_item_id);
SELECT pi.phase_item_id, pi.loader_name, pi.status
FROM hr_dm_phase_items pi,
hr_dm_tables tbl
WHERE (pi.status = 'NS')
AND (pi.phase_id = l_phase_id)
AND (pi.loader_name = tbl.loader_name);
SELECT request_id
FROM hr_dm_migration_requests
WHERE phase_item_id = l_phase_item_id;
SELECT business_group_id
FROM hr_dm_migrations
WHERE migration_id = p_migration_id;
hr_dm_utility.update_phase_items(p_new_status => 'E',
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 => 'S',
p_id => l_phase_item_id);
hr_dm_utility.update_phase_items(p_new_status => 'E',
p_id => l_phase_item_id);
hr_dm_utility.update_phase_items(p_new_status => 'E',
p_id => l_phase_item_id);
hr_dm_utility.update_phase_items(p_new_status => 'E',
p_id => l_phase_item_id);