The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT response_header_id, c.error_code, interpreted_value_code
FROM WSH_CC_TRANS_CONTROL c, WSH_GTC_RESPONSE_RULES r
WHERE transaction_control_id = trans_control_id and c.error_code = r.error_code(+) ;
SELECT l.error_code error_code, l.error_type error_type,
denied_party_flag, embargo_flag, license_required
FROM WSH_CC_RESPONSE_LINES l
WHERE response_header_id = resp_header_id;
SELECT interpreted_value_code
FROM WSH_GTC_RESPONSE_RULES
WHERE error_type = p_error_type and nvl(error_code,p_error_code) = p_error_code
ORDER BY error_code;