APPS.PO_XML_UTILS_GRP dependencies on PO_HEADERS_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 110: from po_headers_all

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
110: from po_headers_all
111: where po_header_id = p_release_id;
112: end if;
113:
114: exception

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:

Line 270: from po_headers_all pha

266:
267: elsif (upper(p_po_type) = 'STANDARD') then
268: select pha.segment1, pha.org_id
269: into l_po_number, l_org_id
270: from po_headers_all pha
271: where pha.po_header_id = p_po_header_id;
272: /*
273: else ideally we should raise an exception.
274: */

Line 348: from po_headers_all glblH, po_lines_all glblSPO

344: begin
345:
346: select glblH.segment1
347: into x_GLOBALCONTRACT
348: from po_headers_all glblH, po_lines_all glblSPO
349: where glblSPO.po_line_id = p_po_line_id and
350: glblSPO.from_header_id = glblH.po_header_id and
351: glblH.global_agreement_flag = 'Y';
352: