APPS.PO_EDA_DATATEMPLATE_PKG dependencies on PON_AUCTION_HEADERS_ALL

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 2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '

2626: (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = 'FED_PRESOL' AND STATUS = 'ACTIVE')
2627: AND field_code = 'FED_DESC';
2628:
2629: l_sql_query :='SELECT '|| l_col_name ||
2630: ' FROM pon_form_field_values WHERE OWNING_ENTITY_CODE = ''PON_AUCTION_HEADERS_ALL'' AND ENTITY_PK1 IN (SELECT DISTINCT AUCTION_HEADER_ID FROM po_lines_merge_v WHERE po_header_id = '
2631: || DOCUMENTID ||'AND draft_id = '||
2632: DRAFTID ||') AND FORM_ID = (SELECT FORM_ID FROM PON_FORMS_SECTIONS WHERE FORM_CODE = ''FED_PRESOL'' AND STATUS = ''ACTIVE'') ';
2633:
2634: open c_addr for l_sql_query;