119: UNION ALL
120: SELECT 'Exists'
121: FROM po_lines_gt pol, --
122: po_line_locations_gt pll, --
123: po_headers_gt potoapp --
125: AND pol.po_line_id = pll.po_line_id
126: AND pol.po_header_id = potoapp.po_header_id
127: AND potoapp.po_header_id = X_po_header_id
201: )
202: INTO X_current_amount
203: FROM po_lines_gt pol, --
204: po_line_locations_gt pll, --
205: po_headers_gt potoapp --
207: AND pol.po_line_id = pll.po_line_id
208: AND pol.po_header_id = potoapp.po_header_id
209: AND potoapp.po_header_id = X_po_header_id