APPS.PO_HEADERS_SV9 dependencies on PO_LINES_ALL

Line 243: FROM po_lines_all pl,

239: --
240: ELSIF nvl(p_ga_flag, 'N') = 'Y' and x_document_type_code = 'BLANKET' THEN
241: SELECT count(1)
242: INTO l_po_exists_num
243: FROM po_lines_all pl,
244: po_headers_all ph
245: WHERE pl.from_header_id = l_po_header_id
246: AND ph.po_header_id = pl.po_header_id
247: AND ph.creation_date >= X_start_date;

Line 346: FROM po_lines_all pl,

342: --
343: ELSIF nvl(p_ga_flag, 'N') = 'Y' and x_document_type_code = 'BLANKET' THEN
344: SELECT count(1)
345: INTO l_po_exists_num
346: FROM po_lines_all pl,
347: po_headers_all ph
348: WHERE pl.from_header_id = l_po_header_id AND
349: ph.po_header_id = pl.po_header_id AND
350: ph.creation_date >= X_start_date;