APPS.PO_RELEASE_DELETE_S SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 16

X_delete_quantity		  NUMBER      := 0;

Line: 19

SELECT pll.line_location_id,
       pll.po_line_id,
       pll.quantity
FROM   po_line_locations pll
WHERE  pll.po_release_id = X_po_release_id;

Line: 38

				  X_delete_quantity;

Line: 45

     UPDATE po_lines
     SET    quantity   = quantity - X_Delete_quantity
     WHERE  po_line_id = X_po_line_id;

Line: 60

END delete_release_update;