APPS.PA_UTILS dependencies on PO_LINES

Line 732: po_lines pol

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

Line 749: po_lines pol

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

Line 1562: po_lines pol

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

Line 1579: po_lines pol

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