DBA Data[Home] [Help]

APPS.PON_BID_DEFAULTING_PKG dependencies on PON_AUCTION_SHIPMENTS_ALL

Line 237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

233: sysdate, -- LAST_UPDATE_DATE
234: p_userid, -- LAST_UPDATED_BY
235: null, -- LAST_UPDATE_LOGIN
236: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
237: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
238: WHERE apb.auction_header_id = p_auc_header_id
239: AND aip.auction_header_id = apb.auction_header_id
240: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
241: AND aip.line_number = apb.line_number

Line 623: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip

619: sysdate, -- LAST_UPDATE_DATE
620: p_userid, -- LAST_UPDATED_BY
621: null, -- LAST_UPDATE_LOGIN
622: apb.has_price_differentials_flag -- HAS_PRICE_DIFFERENTIALS_FLAG
623: FROM pon_auction_shipments_all apb, pon_auction_item_prices_all aip
624: WHERE apb.auction_header_id = p_auc_header_id
625: AND apb.line_number BETWEEN p_batch_start AND p_batch_end
626: AND aip.auction_header_id = apb.auction_header_id
627: AND aip.line_number = apb.line_number

Line 2149: FROM pon_auction_shipments_all apb,

2145: null, -- LAST_UPDATE_LOGIN
2146: apb.has_price_differentials_flag, -- HAS_PRICE_DIFFERENTIALS_FLAG
2147: null, -- UNIT_PRICE
2148: null -- BID_CURRENCY_UNIT_PRICE
2149: FROM pon_auction_shipments_all apb,
2150: pon_bid_item_prices bl
2151: WHERE apb.auction_header_id = p_auc_header_id
2152: AND bl.bid_number = p_bid_number
2153: AND bl.line_number = apb.line_number