APPS.PO_CORE_S3 dependencies on PON_AUCTION_HEADERS_ALL
Line 186: l_fon_name pon_auction_headers_all.document_number%TYPE;
182: IS
183: --
184: -- This function would return Fair Opportunity Reference for the fon_ref_id passed.
185: -- 186: l_fon_name pon_auction_headers_all.document_number%TYPE; 187: l_progress VARCHAR2(3) := NULL;
188: BEGIN
189:
190: SELECT document_number
Line 192: FROM pon_auction_headers_all paha
188: BEGIN
189:
190: SELECT document_number
191: INTO l_fon_name 192: FROM pon_auction_headers_all paha 193: WHERE paha.auction_header_id = p_fon_ref_id;
194:
195: l_progress := '010';
196: