APPS.PO_SOURCING2_SV dependencies on PO_HEADERS_ALL

Line 339: po_headers_all poh -- 5684820

335: CURSOR unit_price IS
336: SELECT pll.price_override,
337: pll.line_location_id -- SERVICES FPJ
338: FROM po_line_locations_all pll, -- GA FPI
339: po_headers_all poh -- 5684820
340: /*
341: Bug fix for 2687718.
342: Added QUOTATION in the WHERE clause to ensure that pricing works when
343: a Standard PO is sourced to a Quotation through the Supplier Catalog.

Line 480: FROM po_headers_all ph,

476: SELECT ph.type_lookup_code,
477: pl.po_header_id
478: INTO l_source_document_type,
479: l_source_document_header_id
480: FROM po_headers_all ph,
481: po_lines_all pl
482: WHERE ph.po_header_id = pl.po_header_id
483: AND pl.po_line_id = p_po_line_id;
484: ELSE

Line 491: FROM po_headers_all ph

487: SELECT ph.type_lookup_code,
488: ph.po_header_id
489: INTO l_source_document_type,
490: l_source_document_header_id
491: FROM po_headers_all ph
492: WHERE ph.po_header_id = p_contract_id;
493: ELSE
494: l_source_document_type := NULL;
495: l_source_document_header_id := NULL;