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 1498: PO_RELEASES_ARCHIVE PORA

1494: from sys.dual
1495: where exists(
1496: select null
1497: FROM PO_RELEASES POR,
1498: PO_RELEASES_ARCHIVE PORA
1499: WHERE POR.po_release_id = p_doc_id
1500: AND POR.po_release_id = PORA.po_release_id
1501: AND PORA.latest_external_flag (+) = 'Y'
1502: AND (

Line 1847: from po_releases_archive

1843: l_progress := '055';
1844: BEGIN
1845: select 'Y'
1846: into l_Archive_Record_Exists
1847: from po_releases_archive
1848: where po_release_id = p_doc_id and rownum = 1;
1849: EXCEPTION
1850: WHEN NO_DATA_FOUND THEN
1851: l_Archive_Record_Exists := 'N';