APPS.PO_COMMUNICATION_PVT dependencies on PO_RELEASES_ARCHIVE_ALL

Line 2878: from po_releases_archive_all

2874: and authorization_status = 'APPROVED';
2875: ELSE
2876: select max(revision_num)
2877: into l_revision_num
2878: from po_releases_archive_all
2879: where po_release_id = p_document_id
2880: and authorization_status = 'APPROVED';
2881: END IF;
2882: Exception

Line 6151: from po_headers_archive_all pb, po_releases_archive_all pr

6147: and ''Y'' = decode(nvl(pllaa.cancel_flag,''N''),''N'',''Y'',''Y'',decode(pllaa.revision_num,PO_COMMUNICATION_PVT.getRevisionNum(),''Y'',''N'') ) )
6148: and plx.po_header_id = phx.po_header_id
6149: AND plx.REVISION_NUM = (select /*+ push_subq no_unnest */ max(revision_num) from po_lines_archive_all pla where pla.po_line_id = plx.po_line_id
6150: and pla.revision_num <= (select max(pb.revision_num)
6151: from po_headers_archive_all pb, po_releases_archive_all pr
6152: where pb.po_header_id = pr.po_header_id
6153: and pr.po_release_id = pcgt.po_release_id
6154: and pr.revision_num= pcgt.revision_number
6155: and pb.approved_date <= pr.approved_date

Line 7343: PO_RELEASES_ARCHIVE_ALL PHA

7339: INTO PO_COMMUNICATION_PVT.g_arcBuyer_fname, PO_COMMUNICATION_PVT.g_arcBuyer_lname, PO_COMMUNICATION_PVT.g_arcAgent_id
7340:
7341: FROM
7342: PER_ALL_PEOPLE_F HRE,
7343: PO_RELEASES_ARCHIVE_ALL PHA
7344: WHERE
7345: HRE.PERSON_ID = PHA.AGENT_ID AND
7346: -- HRE.EMPLOYEE_NUMBER IS NOT NULL AND --
7347: TRUNC(SYSDATE) BETWEEN HRE.EFFECTIVE_START_DATE AND HRE.EFFECTIVE_END_DATE AND