APPS.PO_COMMUNICATION_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 2490: from po_releases_archive_all

2486: and authorization_status = 'APPROVED';
2487: ELSE
2488: select max(revision_num)
2489: into l_revision_num
2490: from po_releases_archive_all
2491: where po_release_id = p_document_id
2492: and authorization_status = 'APPROVED';
2493: END IF;
2494: Exception

Line 5266: from po_headers_archive_all pb, po_releases_archive_all pr

5262: and ''Y'' = decode(nvl(pllaa.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllaa.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) )
5263: and plx.po_header_id = phx.po_header_id
5264: AND plx.REVISION_NUM = (select max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
5265: and pla.revision_num <= (select max(pb.revision_num)
5266: from po_headers_archive_all pb, po_releases_archive_all pr
5267: where pb.po_header_id = pr.po_header_id
5268: and pr.po_release_id = pcgt.po_release_id
5269: and pr.revision_num= pcgt.revision_number
5270: and pb.approved_date <= pr.approved_date

Line 6233: PO_RELEASES_ARCHIVE_ALL PHA

6229: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname, PO_COMMUNICATION_PVT.g_arcAgent_id
6230:
6231: FROM
6232: PER_ALL_PEOPLE_F HRE,
6233: PO_RELEASES_ARCHIVE_ALL PHA
6234: WHERE
6235: HRE.PERSON_ID = PHA.AGENT_ID AND
6236: -- HRE.EMPLOYEE_NUMBER IS NOT NULL AND --
6237: TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND