The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT business_group_id
FROM per_business_groups
WHERE business_group_id = r_migration_data.business_group_id;
SELECT count(*)
FROM hr_dm_migrations
WHERE status IN ('S', 'NS', 'E');
SELECT status
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id);
SELECT request_id
FROM hr_dm_migration_requests
WHERE (migration_id = r_migration_data.migration_id)
AND (master_slave <> 'M');
SELECT business_group_id
FROM per_business_groups
WHERE business_group_id = r_migration_data.business_group_id;
SELECT business_group_created
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id);
SELECT business_group_id
FROM per_business_groups
WHERE business_group_id = r_migration_data.business_group_id;
SELECT count(*)
FROM hr_dm_migrations
WHERE status IN ('S', 'NS', 'E');
SELECT status
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id);
SELECT status
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id);
SELECT business_group_id
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id)
AND (UPPER(source_database_instance) =
UPPER(r_migration_data.source_database_instance))
AND (UPPER(destination_database_instance) =
UPPER(r_migration_data.destination_database_instance));
SELECT MAX(effective_date)
FROM hr_dm_migrations
WHERE (status = 'F')
AND (business_group_id = l_business_group_id)
AND (migration_type = 'FW')
AND
(
(
UPPER(source_database_instance) =
UPPER(r_migration_data.source_database_instance)
AND
UPPER(destination_database_instance) =
UPPER(r_migration_data.destination_database_instance)
)
OR
(
UPPER(source_database_instance) =
UPPER(r_migration_data.destination_database_instance)
AND
UPPER(destination_database_instance) =
UPPER(r_migration_data.source_database_instance)
)
);
SELECT MAX(effective_date)
FROM hr_dm_migrations
WHERE (status = 'F')
AND (business_group_id = l_business_group_id)
AND (migration_type = l_migration_type_test)
AND (effective_date > NVL(l_last_fw_date,
hr_general.start_of_time))
AND
(
(
UPPER(source_database_instance) =
UPPER(r_migration_data.source_database_instance)
AND
UPPER(destination_database_instance) =
UPPER(r_migration_data.destination_database_instance)
)
OR
(
UPPER(source_database_instance) =
UPPER(r_migration_data.destination_database_instance)
AND
UPPER(destination_database_instance) =
UPPER(r_migration_data.source_database_instance)
)
);
SELECT source_database_instance, destination_database_instance
FROM hr_dm_migrations
WHERE (migration_id = r_migration_data.migration_id);