APPS.RG_ROW_ORDERS_PKG SQL Statements

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

Line: 8

        SELECT rg_row_orders_s.nextval
        INTO   new_sequence_number
        FROM   dual;

Line: 32

     SELECT count(*)
     INTO   rec_returned
     FROM   rg_row_orders
     WHERE  row_order_id <> cur_row_order_id
     AND    name = new_name
     AND    application_id = cur_application_id;

Line: 50

    SELECT 1 INTO dummy FROM sys.dual
    WHERE NOT EXISTS
      (SELECT 1
       FROM   rg_reports
       WHERE  row_order_id = X_row_order_id);