DBA Data[Home] [Help]

APPS.PO_CONTERMS_UTL_GRP dependencies on PO_HEADERS_ARCHIVE_ALL

Line 1624: ,po_headers_archive_all poha

1620: ,l_po_attrib_tbl(29) --
1621:
1622: FROM
1623: po_headers_all poh
1624: ,po_headers_archive_all poha
1625: WHERE poh.po_header_id = p_doc_id
1626: AND poh.po_header_id = poha.po_header_id
1627: AND poha.latest_external_flag = 'Y';
1628:

Line 2639: FROM po_headers_archive_all poha

2635: BEGIN
2636:
2637: SELECT poha.conterms_exist_flag
2638: INTO l_archived_conterms_flag
2639: FROM po_headers_archive_all poha
2640: WHERE poha.po_header_id = p_header_id
2641: AND poha.revision_num = l_signed_revision_num;
2642:
2643: EXCEPTION

Line 3356: FROM po_headers_archive_all poha

3352: -- SQL What: Query to check if the last archived version had conterms
3353: -- SQL Why: To check if the conterms were applied to the last archived rev
3354: SELECT nvl(poha.conterms_exist_flag,'N')
3355: INTO l_archived_conterms_flag
3356: FROM po_headers_archive_all poha
3357: WHERE poha.po_header_id = p_po_header_id
3358: AND poha.latest_external_flag = 'Y';
3359:
3360: Return l_archived_conterms_flag;