The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT decode( m2a_dblink,
null, '',
'@'||m2a_dblink)
INTO p_dblink
FROM MSC_APPS_INSTANCES
WHERE instance_id = p_instance_id;
select query
from msd_dem_queries mdq,
msd_dem_entity_queries mdeq
where mdeq.part1 = mdq.query_id
and mdeq.entity_name = p_entity_name;
select query
from msd_dem_queries mdq,
msd_dem_entity_queries mdeq
where mdeq.part2 = mdq.query_id
and mdeq.entity_name = p_entity_name;
select query
from msd_dem_queries mdq,
msd_dem_entity_queries mdeq
where mdeq.part3 = mdq.query_id
and mdeq.entity_name = p_entity_name;
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name;
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name;
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name;
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part1 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part2 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
open c_get_parts for select query from msd_dem_queries mdq,msd_dem_entity_queries mdeq where mdeq.part3 = mdq.query_id and mdeq.entity_name = p_entity_name||'_V';
execute immediate 'SELECT 1 FROM ' || cv_name || v_srdblink || ' WHERE 1 = 2 ' INTO x_is_view_valid;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = p_entity_name
AND mdq.query_id = mdeq.part1;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = p_entity_name
AND mdq.query_id = mdeq.part2;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = p_entity_name
AND mdq.query_id = mdeq.part3;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = x_view_name
AND mdq.query_id = mdeq.part1;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = x_view_name
AND mdq.query_id = mdeq.part2;
OPEN xc_get_parts FOR SELECT query
FROM msd_dem_entity_queries mdeq,
msd_dem_queries mdq
WHERE mdeq.entity_name = x_view_name
AND mdq.query_id = mdeq.part3;
EXECUTE IMMEDIATE 'SELECT 1 FROM ' || x_view_name || v_srdblink || ' WHERE 1 = 2 ' INTO x_is_view_valid;