The following lines contain the word 'select', 'insert', 'update' or 'delete':
select bav.score,paa.attr_max_score,paa.weight
from pon_bid_attribute_values bav,
pon_auction_attributes paa
where bav.auction_header_id=auctionId and
bav.auction_header_id=paa.auction_header_id and
bav.bid_number = bidNumber and
bav.attribute_name=paa.attribute_name and
paa.attr_group=attrGroup;
select nvl(hdr_attr_enable_weights,'N') into weightEnabledVarchar
from pon_auction_headers_all
where auction_header_id=auctionId;
SELECT
DECODE (NVL(pah.HDR_ATTR_ENABLE_WEIGHTS, 'N')
, 'Y', SUM(NVL(pba.WEIGHTED_SCORE, 0))
, 'N', SUM(NVL(pba.SCORE, 0))
) INTO v_bid_total_score
FROM pon_bid_attribute_values pba, pon_auction_headers_all pah
WHERE pba.BID_NUMBER = p_bid_number
and pba.LINE_NUMBER = -1
and pba.AUCTION_HEADER_ID = pah.auction_header_id
GROUP BY pah.HDR_ATTR_ENABLE_WEIGHTS;