APPS.PO_DOCUMENT_CONTROL_PVT dependencies on PO_RELEASES_ARCHIVE

Line 3282: UPDATE po_releases_archive pra

3278:
3279: /* Bug 2781710: We should update the note_to_vendor column
3280: in the archive table also. */
3281:
3282: UPDATE po_releases_archive pra
3283: SET pra.note_to_vendor = p_note_to_vendor
3284: WHERE pra.po_release_id = p_doc_id AND
3285: pra.revision_num = (SELECT por.revision_num
3286: FROM po_releases por

Line 5316: FROM po_releases_archive_all

5312: ELSE
5313: l_progress :='004';
5314: SELECT Count(1)
5315: INTO l_archive_count
5316: FROM po_releases_archive_all
5317: WHERE po_release_id = p_doc_id;
5318:
5319: END IF;
5320: