APPS.AR_MOVEMENT_STAT_PKG SQL Statements

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

Line: 38

      SELECT   mtl.movement_id, lin.customer_trx_line_id
      FROM     mtl_movement_statistics mtl, ra_customer_trx_lines lin
       WHERE   lin.movement_id = mtl.movement_id
        AND    lin.movement_id is not null
        AND    lin.customer_trx_id = a_customer_trx_id
        AND    lin.line_type = 'LINE' FOR UPDATE OF
               mtl.movement_id NOWAIT;

Line: 62

             UPDATE mtl_movement_statistics
                SET invoice_id = p_customer_trx_id,
                    invoice_batch_id = p_batch_id,
                    customer_trx_line_id = lines.customer_trx_line_id,
                    last_update_date = sysdate,
                    last_updated_by = user_id
                WHERE movement_id = lines.movement_id;