APPS.PON_COMPARE_ATTR_PKG SQL Statements

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

Line: 7

      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;

Line: 22

select nvl(hdr_attr_enable_weights,'N') into weightEnabledVarchar
from pon_auction_headers_all
where auction_header_id=auctionId;

Line: 59

    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;