APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUCTION_ATTRIBUTES

Line 417: FROM pon_auction_attributes aa

413: aa.sequence_number, -- SEQUENCE_NUMBER
414: aa.attr_level, -- ATTR_LEVEL
415: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
416: aa.attr_disp_seq_number -- ATTR_DISP_SEQ_NUMBER
417: FROM pon_auction_attributes aa
418: WHERE aa.auction_header_id = p_auc_header_id
419: AND aa.line_number BETWEEN p_batch_start AND p_batch_end
420: AND NOT EXISTS
421: (SELECT pbav.attribute_name

Line 1785: FROM pon_auction_attributes aa,

1781: 0, ba.weighted_score, null), 'Y', NULL), -- WEIGHTED_SCORE
1782: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1783: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1784: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1785: FROM pon_auction_attributes aa,
1786: pon_bid_attribute_values ba,
1787: pon_auction_attributes old_aa
1788: WHERE aa.auction_header_id = p_auc_header_id
1789: AND aa.line_number= -1

Line 1787: pon_auction_attributes old_aa

1783: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1784: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1785: FROM pon_auction_attributes aa,
1786: pon_bid_attribute_values ba,
1787: pon_auction_attributes old_aa
1788: WHERE aa.auction_header_id = p_auc_header_id
1789: AND aa.line_number= -1
1790: AND ba.bid_number (+) = p_source_bid_num
1791: AND ba.line_number (+) = aa.line_number

Line 1893: FROM pon_auction_attributes aa,

1889: decode(bl.has_bid_flag, 'Y', ba.weighted_score, null), -- WEIGHTED_SCORE
1890: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1891: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1892: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1893: FROM pon_auction_attributes aa,
1894: pon_bid_attribute_values ba,
1895: pon_bid_item_prices bl
1896: WHERE aa.auction_header_id = p_auc_header_id
1897: AND aa.line_number > 0