APPS.PO_DOCUMENT_REVISION_GRP dependencies on PO_RELEASES_ARCHIVE

Line 634: PO_RELEASES_ARCHIVE PORA

630: l_progress := '000';
631: SELECT POR.revision_num, nvl(PORA.revision_num, -1)
632: INTO l_revision_num, l_archived_number
633: FROM PO_RELEASES POR,
634: PO_RELEASES_ARCHIVE PORA
635: WHERE POR.po_release_id = p_doc_id
636: AND POR.po_release_id = PORA.po_release_id (+)
637: AND PORA.latest_external_flag (+) = 'Y';
638:

Line 1549: PO_RELEASES_ARCHIVE PORA

1545: from sys.dual
1546: where exists(
1547: select null
1548: FROM PO_RELEASES POR,
1549: PO_RELEASES_ARCHIVE PORA
1550: WHERE POR.po_release_id = p_doc_id
1551: AND POR.po_release_id = PORA.po_release_id
1552: AND PORA.latest_external_flag (+) = 'Y'
1553: AND (

Line 1909: from po_releases_archive

1905: l_progress := '055';
1906: BEGIN
1907: select 'Y'
1908: into l_Archive_Record_Exists
1909: from po_releases_archive
1910: where po_release_id = p_doc_id and rownum = 1;
1911: EXCEPTION
1912: WHEN NO_DATA_FOUND THEN
1913: l_Archive_Record_Exists := 'N';