APPS.PON_NEGOTIATION_PUBLISH_PVT dependencies on PON_AUCTION_EXHIBIT_DETAILS

Line 276: FROM pon_auction_exhibit_details

272:
273: BEGIN
274: SELECT Count(*)
275: INTO l_exhibits_links
276: FROM pon_auction_exhibit_details
277: WHERE AUCTION_HEADER_ID=p_auction_header_id
278: AND ASSOCIATED_TO_LINE IS null;
279:
280: IF(l_exhibits_links>0) then

Line 302: FROM pon_auction_exhibit_details exhibits

298: sysdate, -- CREATION_DATE
299: p_user_id, -- LAST_UPDATED_BY
300: sysdate, -- LAST_UPDATE_DATE
301: p_login_id
302: FROM pon_auction_exhibit_details exhibits
303: WHERE AUCTION_HEADER_ID=p_auction_header_id
304: AND ASSOCIATED_TO_LINE IS NULL
305: ); -- LAST_UPDATE_LOGIN
306:

Line 325: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO

321: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,
322: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner
323: where items_inner.line_number = AuctionExhibitsEO.ASSOCIATED_TO_LINE
324: AND items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID) as IS_LINE_PRICED
325: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO
326: WHERE AuctionExhibitsEO.AUCTION_HEADER_ID = p_auction_header_id
327: AND Nvl(is_cdrl,'N') = 'N') -- This validation is not required for cdrl exhibits.
328: WHERE IS_EXHIBIT_PRICED = IS_LINE_PRICED;
329:

Line 361: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO

357: AND ROWNUM=1),0) as IS_EXHIBIT_PRICED,
358: (select decode(clm_cost_constraint,'NSP',0,'NC',0,1) from pon_auction_item_prices_all items_inner
359: where items_inner.line_number = AuctionExhibitsEO.ASSOCIATED_TO_LINE
360: AND items_inner.auction_header_id = AuctionExhibitsEO.AUCTION_HEADER_ID) as IS_LINE_PRICED
361: FROM PON_AUCTION_EXHIBIT_DETAILS AuctionExhibitsEO
362: WHERE AuctionExhibitsEO.AUCTION_HEADER_ID = p_auction_header_id) Lines
363: WHERE Lines.IS_EXHIBIT_PRICED = Lines.IS_LINE_PRICED
364: ); -- LAST_UPDATE_LOGIN
365: