APPS.PO_DOCUMENT_CHECKS_GRP dependencies on PO_HEADERS_ALL

Line 121: l_consigned_flag PO_HEADERS_ALL.CONSIGNED_CONSUMPTION_FLAG%TYPE;

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

Line 1319: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;

1315: l_log_head CONSTANT VARCHAR2(100):= g_log_head || l_api_name;
1316: l_api_version CONSTANT NUMBER := 1.0;
1317: l_progress VARCHAR2(3) := '000';
1318:
1319: l_has_ga_ref PO_HEADERS_ALL.global_agreement_flag%TYPE;
1320: l_allow_price_override PO_LINES_ALL.allow_price_override_flag%TYPE;
1321: l_accrue_invoice_count NUMBER;
1322: l_pending_rcv_transactions NUMBER;
1323: l_archive_mode_std_po PO_DOCUMENT_TYPES.archive_external_revision_code%TYPE;

Line 1372: po_headers_all REFH,

1368: NVL(REFL.allow_price_override_flag, 'N')
1369: INTO l_has_ga_ref,
1370: l_allow_price_override
1371: FROM po_lines_all POL,
1372: po_headers_all REFH,
1373: po_lines_all REFL
1374: WHERE POL.po_line_id = p_po_line_id
1375: AND REFH.po_header_id (+) = POL.from_header_id -- JOIN
1376: AND REFL.po_line_id (+) = POL.from_line_id; -- JOIN