APPS.PON_AUCTION_PO_PKG dependencies on PON_BID_ITEM_PRICES

Line 322: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;

318:
319: newline varchar2(256);
320: tab varchar2(256);
321: header_note pon_bid_headers.note_to_auction_owner%TYPE;
322: line_note pon_bid_item_prices.note_to_auction_owner%TYPE;
323: msgBidHeaderNote varchar2(2000);
324: msgBidLineNote varchar2(2000);
325: x_msg_suffix VARCHAR2(3) := '';
326: x_doctype_group_name pon_auc_doctypes.doctype_group_name%TYPE;

Line 351: FROM pon_bid_headers pbh, pon_bid_item_prices pbip

347:
348: IF l_contract_type <> 'CONTRACT' THEN
349: SELECT replace(pbh.note_to_auction_owner, fnd_global.local_chr(13)), replace(pbip.note_to_auction_owner, fnd_global.local_chr(13))
350: INTO header_note, line_note
351: FROM pon_bid_headers pbh, pon_bid_item_prices pbip
352: WHERE pbh.auction_header_id = p_auction_header_id and
353: pbh.bid_number = p_bid_number and
354: pbip.bid_number = pbh.bid_number and
355: pbip.line_number = p_line_number;