DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on PO_RELEASES_ALL

Line 105: from po_headers_all pha, po_releases_all pra

101: begin
102: if (upper(p_po_type) = 'RELEASE') then
103: /*
104: select pha.segment1 into p_blanket_po_num
105: from po_headers_all pha, po_releases_all pra
106: where pra.po_header_id = pha.po_header_id and
107: pra.po_release_id = p_release_id;
108: */
109: select segment1 into p_blanket_po_num

Line 262: from po_releases_all pra, po_headers_all pha

258:
259: if (upper(p_po_type) = 'RELEASE') then
260: select pha.segment1, pha.org_id
261: into l_po_number, l_org_id
262: from po_releases_all pra, po_headers_all pha
263: where pra.po_release_id = p_po_header_id
264: and pra.po_header_id = pha.po_header_id;
265:
266: