APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_HEADERS_ALL

Line 120: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;

116: l_document_id_tbl po_tbl_number;
117:
118: l_doc_id NUMBER;
119:
120: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;
121:
122: BEGIN
123:
124: -- Initialize variables

Line 1309: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;

1305: l_log_head CONSTANT VARCHAR2(100):= g_log_head || l_api_name;
1306: l_api_version CONSTANT NUMBER := 1.0;
1307: l_progress VARCHAR2(3) := '000';
1308:
1309: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;
1310: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1311: l_accrue_invoice_count NUMBER;
1312: l_pending_rcv_transactions NUMBER;
1313: l_archive_mode_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

Line 1362: po_headers_all REFH,

1358: NVL(REFL.allow_price_override_flag, 'N')
1359: INTO l_has_ga_ref,
1360: l_allow_price_override
1361: FROM po_lines_all POL,
1362: po_headers_all REFH,
1363: po_lines_all REFL
1364: WHERE POL.po_line_id = p_po_line_id
1365: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN
1366: AND REFL.po_line_id (+) = POL.from_line_id; -- JOIN