APPS.PO_DOCUMENT_ACTION_UTIL dependencies on PO_HEADERS_ALL

Line 531: FROM po_headers_all poh

527: d_progress := 40;
528:
529: SELECT poh.agent_id
530: INTO x_preparer_id
531: FROM po_headers_all poh
532: WHERE poh.po_header_id = p_document_id;
533:
534: d_progress := 50;
535: IF (PO_LOG.d_stmt) THEN

Line 1069: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;

1065: l_rollup_msg VARCHAR2(256);
1066: l_ctl_replaced_null_entry BOOLEAN := FALSE;
1067: l_count_hist NUMBER;
1068:
1069: l_revision_num PO_HEADERS_ALL.revision_num%TYPE;
1070:
1071: BEGIN
1072:
1073: d_progress := 0;

Line 1262: FROM po_headers_all poh

1258: -- so we're safe using headers_all
1259:
1260: SELECT max(poh.revision_num)
1261: INTO l_revision_num
1262: FROM po_headers_all poh
1263: WHERE poh.po_header_id = p_document_id;
1264:
1265: d_progress := 160;
1266: IF (PO_LOG.d_stmt) THEN

Line 1788: FROM PO_HEADERS_ALL poh

1784: WHERE poll.po_header_id = p_document_id
1785: AND poll.po_release_id IS NULL
1786: AND NVL(poll.approved_flag, 'N') <> 'Y'
1787: AND EXISTS ( SELECT 'PO Does not require signature'
1788: FROM PO_HEADERS_ALL poh
1789: WHERE poh.po_header_id = poll.po_header_id
1790: AND NVL(poh.pending_signature_flag, 'N') <> 'Y');
1791:
1792: END IF; -- p_new_status = g_doc_status_APPROVED