The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT mapping_id
FROM hxc_mappings
WHERE name = p_mapping_name;
SELECT mapping_component_id
FROM hxc_mapping_components
WHERE name = p_name;
SELECT mcu.mapping_comp_usage_id
, mcu.object_version_number
, DECODE( NVL( mcu.last_updated_by,-1), 1, 'SEED', 'CUSTOM')
INTO l_mapping_comp_usage_id
, l_ovn
, l_owner
FROM hxc_mapping_comp_usages mcu
, hxc_mapping_components mpc
WHERE mpc.name = P_NAME
AND mcu.mapping_component_id = mpc.mapping_component_id
AND mcu.mapping_id = l_mapping_id;