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 1581: FROM pon_auction_attributes aa,

1577: 0, ba.weighted_score, null), 'Y', NULL), -- WEIGHTED_SCORE
1578: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1579: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1580: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1581: FROM pon_auction_attributes aa,
1582: pon_bid_attribute_values ba,
1583: pon_auction_attributes old_aa
1584: WHERE aa.auction_header_id = p_auc_header_id
1585: AND aa.line_number= -1

Line 1583: pon_auction_attributes old_aa

1579: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1580: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1581: FROM pon_auction_attributes aa,
1582: pon_bid_attribute_values ba,
1583: pon_auction_attributes old_aa
1584: WHERE aa.auction_header_id = p_auc_header_id
1585: AND aa.line_number= -1
1586: AND ba.bid_number (+) = p_source_bid_num
1587: AND ba.line_number (+) = aa.line_number

Line 1661: FROM pon_auction_attributes aa,

1657: decode(bl.has_bid_flag, 'Y', ba.weighted_score, null), -- WEIGHTED_SCORE
1658: aa.attr_group_seq_number, -- ATTR_GROUP_SEQ_NUMBER
1659: aa.attr_disp_seq_number, -- ATTR_DISP_SEQ_NUMBER
1660: decode(p_rebid_flag, 'Y', ba.value, null) -- OLD_VALUE
1661: FROM pon_auction_attributes aa,
1662: pon_bid_attribute_values ba,
1663: pon_bid_item_prices bl
1664: WHERE aa.auction_header_id = p_auc_header_id
1665: AND aa.line_number > 0