APPS.PO_ITEMS_SV dependencies on PO_HEADERS_ALL

Line 684: l_doc_type PO_HEADERS_ALL.type_lookup_code%TYPE;

680: l_dummy NUMBER;
681: l_shipment_count NUMBER;
682:
683: --Bug11658279
684: l_doc_type PO_HEADERS_ALL.type_lookup_code%TYPE;
685:
686: BEGIN
687:
688: /* Bug 11658279 START- For a BPA, there may not be shipments when line is saved.

Line 699: FROM po_headers_all

695: IF (p_has_line_been_saved_flag = 'Y') THEN
696:
697:
698: SELECT type_lookup_code INTO l_doc_type
699: FROM po_headers_all
700: WHERE po_header_id = (SELECT po_header_id
701: FROM po_lines_merge_v
702: WHERE po_line_id = p_po_line_id
703: AND draft_id = p_draft_id);