APPS.PA_UTILS dependencies on PO_LINES

Line 804: po_lines pol

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;
808: EXCEPTION /* Bug 6978184 : Added Exception Block */

Line 821: po_lines pol

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
825: and pol.line_num = x_po_line_num;

Line 1816: po_lines pol

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;
1820: EXCEPTION /* Bug 6978184 : Added Exception Block */

Line 1833: po_lines pol

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
1837: and pol.line_num = x_po_line_num;