DBA Data[Home] [Help]

APPS.PO_XML_UTILS_GRP dependencies on PO_RELEASES_ALL

Line 107: from po_headers_all pha, po_releases_all pra

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

Line 264: from po_releases_all pra, po_headers_all pha

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