APPS.QOT_UTILITY_PVT SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 17

	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);

Line: 24

	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;

Line: 30

	SELECT update_allowed_flag
	FROM ASO_QUOTE_STATUSES_B
	WHERE quote_status_id = pc_status_id;

Line: 89

			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');

Line: 108

		--dbms_output.put_line('Quote is in Update Status');

Line: 112

		   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');

Line: 125

			--dbms_output.put_line('Quote is in Update status but security is off..so return U');