APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_ITEM_PRICES

Line 454: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;

450:
451: newline varchar2(256);
452: tab varchar2(256);
453: header_note pon_bid_headers.note_to_auction_owner%TYPE;
454: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;
455: msgBidHeaderNote varchar2(2000);
456: msgBidLineNote varchar2(2000);
457: x_msg_suffix VARCHAR2(3) := '';
458: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

Line 483: FROM pon_bid_headers pbh, pon_bid_item_prices pbip

479:
480: IF l_contract_type <> 'CONTRACT' THEN
481: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
482: INTO header_note, line_note
483: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
484: WHERE pbh.auction_header_id = p_auction_header_id and
485: pbh.bid_number = p_bid_number and
486: pbip.bid_number = pbh.bid_number and
487: pbip.line_number = p_line_number;