The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT resource_id
FROM jtf_rs_resource_extns
WHERE user_id = pc_user_id
AND SYSDATE BETWEEN start_date_active AND NVL(end_date_active, SYSDATE);
SELECT max_version_flag, price_request_id, quote_status_id, quote_number
FROM ASO_QUOTE_HEADERS_ALL
WHERE quote_header_id = pc_quote_header_id;
SELECT update_allowed_flag
FROM ASO_QUOTE_STATUSES_B
WHERE quote_status_id = pc_status_id;
IF (l_status_override <> 'Y' AND (l_qot_access = 'UPDATE' OR l_qot_access = 'READ')) THEN
--dbms_output.put_line('Quote Access is Update or Read and STatus Override is No..View Access');
--dbms_output.put_line('Quote is in Update Status');
IF (l_status_override <> 'Y' AND l_qot_access = 'UPDATE') THEN
--dbms_output.put_line('Quote Access is Update and STatus Override is No..Update Access');
--dbms_output.put_line('Quote is in Update status but security is off..so return U');