APPS.PA_UTILS dependencies on PO_HEADERS

Line 803: from po_headers poh,

799:
800: BEGIN
801: select poh.segment1, pol.line_num
802: into l_po_number, l_po_line_num
803: from po_headers poh,
804: po_lines pol
805: where poh.po_header_id = pol.po_header_id
806: and poh.po_header_id = l_po_header_id
807: and pol.po_line_id = l_po_line_id;

Line 820: from po_headers poh,

816: if (l_po_number <> x_po_number or l_po_line_num <> x_po_line_num ) then
817: /* Bug 6978184 : Added Query and IF below */
818: select poh.po_header_id, pol.po_line_id
819: into l_po_header_id, l_po_line_id
820: from po_headers poh,
821: po_lines pol
822: where poh.po_header_id = pol.po_header_id
823: and poh.type_lookup_code = 'STANDARD'
824: and poh.segment1 = x_po_number

Line 1815: from po_headers poh,

1811:
1812: BEGIN
1813: select poh.segment1, pol.line_num
1814: into l_po_number, l_po_line_num
1815: from po_headers poh,
1816: po_lines pol
1817: where poh.po_header_id = pol.po_header_id
1818: and poh.po_header_id = l_po_header_id
1819: and pol.po_line_id = l_po_line_id;

Line 1832: from po_headers poh,

1828: if (l_po_number <> x_po_number or l_po_line_num <> x_po_line_num) then
1829: /* Bug 6978184 : Added Query and IF below */
1830: select poh.po_header_id, pol.po_line_id
1831: into l_po_header_id, l_po_line_id
1832: from po_headers poh,
1833: po_lines pol
1834: where poh.po_header_id = pol.po_header_id
1835: and poh.type_lookup_code = 'STANDARD'
1836: and poh.segment1 = x_po_number