The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE DeleteObjectDefinition(
p_obj_def_id in number
)
--------------------------------------------------------------------------------
IS
l_api_name constant varchar2(30) := 'DeleteObjectDefinition';
SELECT object_type_code
FROM fem_object_catalog_b
WHERE object_id = (SELECT object_id
FROM fem_object_definition_b
WHERE object_definition_id = p_obj_def_id);
delete from fem_cond_dim_cmp_dtl
where cond_dim_cmp_obj_def_id = p_obj_def_id;
delete from fem_cond_dim_components
where cond_dim_cmp_obj_def_id = p_obj_def_id;
END DeleteObjectDefinition;