APPS.PO_DOCUMENT_ARCHIVE_PVT dependencies on PO_RELEASES_ALL

Line 155: FROM PO_RELEASES_ALL PH,

151: -- SQL Why : Check if the document is approved and not archived
152: SELECT NVL(ph.revision_num, 0),
153: NVL(pha.revision_num, -1)
154: INTO x_revision_num, l_arch_revision_num
155: FROM PO_RELEASES_ALL PH,
156: PO_RELEASES_ARCHIVE_ALL PHA
157: WHERE ph.po_release_id = p_document_id
158: AND ph.approved_date IS NOT NULL
159: AND ph.approved_flag = 'Y'

Line 806: FROM PO_RELEASES_ALL

802: xml_send_date ,
803: 'Y',
804: document_creation_method --
805: , submit_date --
806: FROM PO_RELEASES_ALL
807: WHERE po_release_id = p_document_id;
808:
809: l_progress := '030';
810:

Line 1899: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;

1895: l_continue BOOLEAN := FALSE;
1896:
1897: -- Bug 3648552
1898: l_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
1899: l_po_release_id PO_RELEASES_ALL.po_release_id%TYPE;
1900:
1901:
1902: BEGIN
1903:

Line 2220: FROM po_releases_all

2216: -- PO_DISTRIBUTIONS_ARCHIVE_ALL.po_release_id
2217: IF (p_document_type = 'RELEASE') THEN
2218: SELECT po_header_id
2219: INTO l_po_header_id
2220: FROM po_releases_all
2221: WHERE po_release_id = p_document_id;
2222: l_po_release_id := p_document_id;
2223: ELSE
2224: l_po_header_id := p_document_id;