APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PON_BID_HEADERS

Line 99: from pon_auction_headers_all paha, pon_bid_headers pbh

95: function get_ProcurementInstVehicle3(p_auctHeaderId varchar2) return varchar2 is
96:
97: CURSOR csr_auction_details is
98: SELECT paha.solicitation_type
99: from pon_auction_headers_all paha, pon_bid_headers pbh
100: WHERE pbh.po_header_id = DOCUMENTID
101: and pbh.auction_header_id = paha.auction_header_id;
102:
103: v_instr_type varchar2(10);

Line 220: (SELECT DISTINCT AUCTION_HEADER_ID FROM pon_bid_headers WHERE bid_number in

216: WHERE kartb.article_version_id = ver.article_version_id
217: AND kartb.sav_Sae_id = art.article_id
218: AND ver.article_id = art.article_id
219: AND kartb.document_id in
220: (SELECT DISTINCT AUCTION_HEADER_ID FROM pon_bid_headers WHERE bid_number in
221: (SELECT bid_number FROM po_lines_all WHERE po_header_id = DOCUMENTID))
222: AND kartb.document_type = 'SOLICITATION'
223: AND ( (art.article_title LIKE '52.212-1%' AND ver.INSERT_BY_REFERENCE = 'Y')
224: OR (art.article_title LIKE '52.212-4%' AND ver.INSERT_BY_REFERENCE = 'Y')