APPS.PO_SOURCING2_SV dependencies on PO_HEADERS_ALL

Line 260: po_headers_all poh -- 5684820

256: cursor unit_price IS
257: SELECT pll.price_override,
258: pll.line_location_id -- SERVICES FPJ
259: FROM po_line_locations_all pll, -- GA FPI
260: po_headers_all poh -- 5684820
261: /*
262: Bug fix for 2687718.
263: Added QUOTATION in the WHERE clause to ensure that pricing works when
264: a Standard PO is sourced to a Quotation through the Supplier Catalog.

Line 377: FROM po_headers_all ph,

373: SELECT ph.type_lookup_code,
374: pl.po_header_id
375: INTO l_source_document_type,
376: l_source_document_header_id
377: FROM po_headers_all ph,
378: po_lines_all pl
379: WHERE ph.po_header_id = pl.po_header_id
380: AND pl.po_line_id = p_po_line_id;
381: ELSE

Line 386: FROM po_headers_all ph

382: SELECT ph.type_lookup_code,
383: ph.po_header_id
384: INTO l_source_document_type,
385: l_source_document_header_id
386: FROM po_headers_all ph
387: WHERE ph.po_header_id = p_contract_id;
388: END IF; /*IF (p_po_line_id IS NOT NULL)*/
389:
390: