APPS.PO_SYNC_DRAFT_FROM_ARCHIVE_PVT dependencies on PO_HEADERS_ARCHIVE_ALL

Line 58: FROM PO_HEADERS_ARCHIVE_ALL PHA,

54: END IF;
55: -- SQL What: Select record from Draft which has been copied from Archive
56: -- SQL Why : Check if the document has already been synced from archive to Draft
57: SELECT 'Y' INTO x_return_status
58: FROM PO_HEADERS_ARCHIVE_ALL PHA,
59: PO_DRAFTS PD
60: WHERE pha.po_header_id = p_document_id
61: AND pha.revision_num = p_revision_num
62: AND pd.document_id = pha.po_header_id (+)

Line 742: FROM po_headers_archive_all

738: fon_ref_id,
739: clm_contract_finance_code, --
740: clm_special_contract_type, --
741: clm_payment_instr_code --
742: FROM po_headers_archive_all
743: WHERE po_header_id = p_document_id
744: AND revision_num = p_revision_num;
745:
746:

Line 5555: FROM po_headers_archive_all

5551: --UCA project - CLM R4 Changes Begin.
5552: SELECT Nvl(po_core_s.Retrieveoptionvalue(org_id,
5553: po_core_s.g_undef_cont_act_col), 'N')
5554: INTO l_isucaenabled
5555: FROM po_headers_archive_all
5556: WHERE po_header_id = p_document_id
5557: and revision_num = p_revision_num;
5558:
5559: