APPS.PON_COMPARE_ATTR_PKG dependencies on PON_AUCTION_HEADERS_ALL

Line 23: from pon_auction_headers_all

19:
20: begin
21:
22: select nvl(hdr_attr_enable_weights,'N') into weightEnabledVarchar
23: from pon_auction_headers_all
24: where auction_header_id=auctionId;
25:
26:
27: if (weightEnabledVarchar = 'Y') then

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;