APPS.PON_COMPARE_ATTR_PKG dependencies on PON_BID_ATTRIBUTE_VALUES

Line 8: from pon_bid_attribute_values bav,

4: FUNCTION getGroupAttrTargetValue(auctionId number,bidNumber number,attrGroup varchar2) return number is
5:
6: CURSOR c_record is
7: select bav.score,paa.attr_max_score,paa.weight
8: from pon_bid_attribute_values bav,
9: pon_auction_attributes paa
10: where bav.auction_header_id=auctionId and
11: bav.auction_header_id=paa.auction_header_id and
12: bav.bid_number = bidNumber and

Line 64: FROM pon_bid_attribute_values pba, pon_auction_headers_all pah

60: DECODE (NVL(pah.HDR_ATTR_ENABLE_WEIGHTS, 'N')
61: , 'Y', SUM(NVL(pba.WEIGHTED_SCORE, 0))
62: , 'N', SUM(NVL(pba.SCORE, 0))
63: ) INTO v_bid_total_score
64: FROM pon_bid_attribute_values pba, pon_auction_headers_all pah
65: WHERE pba.BID_NUMBER = p_bid_number
66: and pba.LINE_NUMBER = -1
67: and pba.AUCTION_HEADER_ID = pah.auction_header_id
68: GROUP BY pah.HDR_ATTR_ENABLE_WEIGHTS;