APPS.PA_UTILS dependencies on PO_HEADERS

Line 731: from po_headers poh,

727:
728: BEGIN
729: select poh.segment1, pol.line_num
730: into l_po_number, l_po_line_num
731: from po_headers poh,
732: po_lines pol
733: where poh.po_header_id = pol.po_header_id
734: and poh.po_header_id = l_po_header_id
735: and pol.po_line_id = l_po_line_id;

Line 748: from po_headers poh,

744: if (l_po_number <> x_po_number or l_po_line_num <> x_po_line_num ) then
745: /* Bug 6978184 : Added Query and IF below */
746: select poh.po_header_id, pol.po_line_id
747: into l_po_header_id, l_po_line_id
748: from po_headers poh,
749: po_lines pol
750: where poh.po_header_id = pol.po_header_id
751: and poh.type_lookup_code = 'STANDARD'
752: and poh.segment1 = x_po_number

Line 1561: from po_headers poh,

1557:
1558: BEGIN
1559: select poh.segment1, pol.line_num
1560: into l_po_number, l_po_line_num
1561: from po_headers poh,
1562: po_lines pol
1563: where poh.po_header_id = pol.po_header_id
1564: and poh.po_header_id = l_po_header_id
1565: and pol.po_line_id = l_po_line_id;

Line 1578: from po_headers poh,

1574: if (l_po_number <> x_po_number or l_po_line_num <> x_po_line_num) then
1575: /* Bug 6978184 : Added Query and IF below */
1576: select poh.po_header_id, pol.po_line_id
1577: into l_po_header_id, l_po_line_id
1578: from po_headers poh,
1579: po_lines pol
1580: where poh.po_header_id = pol.po_header_id
1581: and poh.type_lookup_code = 'STANDARD'
1582: and poh.segment1 = x_po_number